When support sqlite, access?

Aug 31, 2013 at 7:00 PM
Will support sqlite, access?
Coordinator
Sep 2, 2013 at 4:48 AM
Yes. Will be ready in 1 to 2 weeks
Coordinator
Sep 9, 2013 at 3:25 AM
Mael,

Speed ​​now supports access and sqlite

SQLite
            string cs = "Data Source=./Test.sqlite;Pooling=true;FailIfMissing=false";
            using (var db = new Database(EnumDbProviderType.SQLite, cs))
            {
                db.Open();

            }
SQLite: In your project install NuGet package: "System.Data.SQLite (x86/x64)" -- Visual Studio / Tools / Library Package Manager / Manage NuGet Packages for Solution



Access 2010
            using (var db = new Database(EnumDbProviderType.Access, "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + Application.StartupPath + @"\bdExemplo.accdb"))

Access 2007
var db = new Database(EnumDbProviderType.Access, "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + Application.StartupPath + @"\bdExemplo.mdb");
Sep 9, 2013 at 11:55 AM
Edited Sep 9, 2013 at 11:57 AM
Hello,why this tools is Without this feature of sqlite and acess database generation?
I need this feature. Thank you
Coordinator
Sep 9, 2013 at 3:47 PM
Download version 1.02.

You can also generate code using, without using the interface, as follows:
            // Access
            using (var db = new Database(EnumDbProviderType.Access, "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + Application.StartupPath + @"\bdExemplo.accdb"))
            // using (var db = new Database(EnumDbProviderType.Access,  "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + Application.StartupPath + @"\bdExemplo.mdb"))
            {
                db.Open();
                db.GenerateTables("TestGen.Access.Data", "TestGen.Access.BL", "../../../TestGen.Access/Data/Base", "../../../TestGen.Access/Data", "../../../TestGen.Access/BL/Base", "../../../TestGen.Access/BL", false, Speed.Data.Generation.EnumNameCase.Pascal);
            }

            // SQLite
            string cs = "Data Source=./Test.sqlite;Pooling=true;FailIfMissing=false";
            using (var db = new Database(EnumDbProviderType.MySql, cs))
            {
                db.Open();
                db.GenerateTables("TestGen.SqlLite.Data", "TestGen.SqlLite.BL", "../../../TestGen.Sqlite/Data/Base", "../../../TestGen.Sqlite/Data", "../../../TestGen.Sqlite/BL/Base", "../../../TestGen.Sqlite/BL", false, Speed.Data.Generation.EnumNameCase.Pascal);
            }
Coordinator
Sep 9, 2013 at 3:55 PM
Version 1.2
Sep 11, 2013 at 2:58 AM
SqlIte: The method does not support the specified

win7 sp1 x64 : china
Coordinator
Sep 11, 2013 at 8:39 PM
Give me details of the problem
Sep 12, 2013 at 2:53 AM
System.Data.Common.DbConnectionStringBuilder CreateConnectionStringBuilder(System.String, System.String, System.String, System.String, Boolean)



namespace Speed.UI.UserControls

private void Connect(bool loadData, bool showMessage)
    {
        this.Cursor = Cursors.WaitCursor;
        try
        {
            if (dbConnect.Connect(showMessage))
            {
                using (var db = dbConnect.GetDb())
                {
                    if (loadData)
                    {
                        CheckObjects(db);
                        browser.Fill(db);
                    }
                }
                //Data Source=./config.db3
                file.Connection = dbConnect.Connection;
                DataToView();

            }
            SetControls();
        }
        catch (Exception ex)
        {
            if (showMessage)
                Program.ShowError(ex.Message + ex.TargetSite);
        }
        SetControls();
        this.Cursor = Cursors.Default;
    }
Coordinator
Sep 12, 2013 at 4:02 AM
If you already have the version with ClickOnce, from the application that auto-update.
Otherwise download the version 1.2.1.2

Please enter in "Host" the full path of the database
Coordinator
Sep 12, 2013 at 9:54 PM
get it?
Sep 22, 2013 at 1:19 AM
Problem has been resolved, thank you