How to connect SqliteDB using BLToolkit on ASP.NET?

Question

Hi i got an error while connection to my sqlitedb.

I create my sqlitedb using Firefox Sqlite Addon.

MyConn : (webconfig)

    <connectionStrings>
             <add name="TARKMANCAS_CONNECTION" connectionString="Data  Source=C:/TARKMANCAS_DB.sqlite;"/>
    </connectionStrings>

MyClass:

public TarkBaseDb()
        : base("TARKMANCAS_CONNECTION")
    {
    }

    // start
    //
    public Table<TarkBaseSchema.KadroGrubuCls> KadroGrubu { get { return GetTable<TarkBaseSchema.KadroGrubuCls>(); } }

TarkBaseSchema:

    [TableName("EGITIM_KADROSU_GRUBU_TAB")]
    public class KadroGrubuCls
    {
        private TarkBaseDb db = new TarkBaseDb();

        #region Contructors

        public KadroGrubuCls()
        {
            using (db)
            {
                var qry = from x in db.KadroGrubu
                          select x;
                foreach (var rec_ in qry)
                {
                    KadroGrubuId = rec_.KadroGrubuId;
                    KadroGrubu = rec_.KadroGrubu;
                }
            }
        }
        #endregion

        #region Data Items
        [MapField("KADRO_GRUBU_ID")]
        [PrimaryKey, NotNull]
        public int KadroGrubuId { get; set; }
        [MapField("KADRO_GRUBU")]
        public string KadroGrubu { get; set; }

        #endregion

        #region Relations
        #endregion

        #region Public Methods

        public KadroGrubuCls Get()
        {
            return (new KadroGrubuCls());
        }

        #endregion

    }

And try a call:

TarkBaseSchema.KadroGrubuCls _tarkKadro = _tarkKadro.Get();

I got error :

  A network-related or instance-specific error occurred while establishing a connection to 
SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. 
(provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)

Similar question was answered here http://stackoverflow.com/questions/12365849/bltoolkit-using-a-mysql-connection/12377798#12377798 — Mladen Macanović, Sep 22 '12 at 09:08

score 2 · Answer 1 · answered Sep 21 '12 at 06:35

2

The error message shows that it's trying to connect to SQL Server, not SQLite.

Change the connection string to select the correct driver.
(And you have two spaces between "Data" and "Source".)

answered Sep 21 '12 at 06:35

CL.

173,858
17
217
259

now error changed , I set my provider to bltoolkit and i got this :Could not load type 'BLToolkit.Data.DataProvider.SQLiteDataProvider' from assembly – Mennan Sep 21 '12 at 09:25
You have to [register the provider](http://bltoolkit.net/doc/Data/DataProvider/index.htm). – CL. Sep 21 '12 at 10:23

score 0 · Answer 2 · answered Jun 28 '16 at 15:58

I think it is an answer for me;)

Linq2db

The best solution - use linq2db

BLToolkit

If you don't want to use linq2db, follow this steps to connect to sqlite db with bltookit.

Install libs

Install nuget packages (or download it manually)

PM> Install-Package BLToolkit.SQLite
PM> Install-Package System.Data.SQLite.Core

Modify web.config / app.config

<configuration>
  <!-- 1 : Add providers to BLToolkit -->
  <bltoolkit>
    <dataProviders>
      <add type="BLToolkit.Data.DataProvider.SQLiteDataProvider, BLToolkit.Data.DataProvider.SQLite.4" />
    </dataProviders>
  </bltoolkit>

  <!-- 2 : Add connection string with the appropriate provider field -->
  <appSettings>
    <add key="ConnectionString.SQLite.localdb" value="Data Source=C:/TARKMANCAS_DB.sqlite;Version=3;Pooling=True;Max Pool Size=10;" />
  </appSettings>
</configuration>

You could find more information about connection strings here: http://www.connectionstrings.com/sqlite/

Create an instance of DbManager

You have used MyClass, so it should looks like:

public class TarkBaseDb: DbManager
{
  public TarkBaseDb()
          : base("SQLite", "TARKMANCAS")
  {
      // definition of your tables
  }
}