Current filter:
                                You should refresh the page.
                                Support Center
                                0
                                  • Hello,

                                    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 1.0.65.0

                                    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)
                                                End If
                                    End If

                                0

                                Hello Mario,

                                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 1.0.61.0 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.

                                Thanks,
                                Dennis

                                If you need additional product information, write to us at info@devexpress.com or call us at +1 (818) 844-3383

                                FOLLOW US

                                DevExpress engineers feature-complete Presentation Controls, IDE Productivity Tools, Business Application Frameworks, and Reporting Systems for Visual Studio, along with high-performance HTML JS Mobile Frameworks for developers targeting iOS, Android and Windows Phone. Whether using WPF, Silverlight, ASP.NET, WinForms, HTML5 or Windows 8, DevExpress tools help you build and deliver your best in the shortest time possible.

                                Copyright © 1998-2014 Developer Express Inc.
                                All trademarks or registered trademarks are property of their respective owners