i can't configure SQLite connection in a XAF application. I have seen the Issue Q96502 which is reference to an
older version of the XAF Framework. It seems that the bug is get into the new version again. When i provide a
connectionstring like "Data Source=C:\Test\Test.s3db" then i get an exception. When i add some code to pass
a SQLLite connection to the XAFApplication Object then it runs ok.
I'm using the newest SQLite ADO.NET Provider 22.214.171.124
This is my Connectionstring from the app.config file
<add name="ConnectionString" connectionString="data source=F:\Programmierung\test.s3db;Version=3;" providerName="System.Data.SQLite" />
This is my Workaround
If (Not ConfigurationManager.ConnectionStrings.Item("ConnectionString") Is Nothing) Then
_application.ConnectionString = ConfigurationManager.ConnectionStrings.Item("ConnectionString").ConnectionString
If ConfigurationManager.ConnectionStrings.Item("ConnectionString").ProviderName = "System.Data.SQLite" Then
_application.Connection = New SQLite.SQLiteConnection(_application.ConnectionString)
Thanks for contacting us. To connect an XAF application to any database supported by XPO, you should follow the instructions given in the Connect an XAF Application to a Database Provider help topic. This is a well-documented scenario and no any hacks is necessary. Please let me know if you find the information from this help topic useful.
Also, when accomplishing this task, take special note of the currently supported databases list published here: Database Systems Supported by XPO
According to this document, the version of the database provider is not currently supported and you should use the System.Data.SQLite.dll 126.96.36.199 assembly with XPO unless you are ready to recompile the DevExpress.Xpo.Providers library with the newest version of the database provider you have. The recompilation of this library is not a recommended solution. Let me know if you want to proceed this way and I will provide you further instructions.
For now, I have attached a working XAF demo working fine for me with currently supported version of the SQLite provider. Let me know if this helps.