SubSonic, SQLite and can't find a data provider?

I'm getting started with SubSonic. I wanted to change my db to sqlite and I have this in my configuration file

  <connectionStrings>
      <add name="NorthwindSQLite"
       connectionString="Data Source=C:\unzipped\WindowsFormsApplication1\my.db"
       providerName="System.Data.SQLite"/>
  </connectionStrings>

I get an exception

A first chance exception of type 'System.ArgumentException' occurred in System.Data.dll

Additional information: Unable to find the requested .Net Framework Data Provider.  It may not be installed.

I have an SQLite link in the link section. So how do I fix this problem?

+3
source share
2 answers

, db System.Data.SQLite . System.Data.SQLite , . , visual studio. , 2.2 sqlite . sqlite, github, , , . " ".

.

+4

?

sqlite :

<add name="Local" type="SubSonic.SQLiteDataProvider, SubSonic" connectionStringName="MyConn" generatedNamespace="X.Data" stripTableText="tbl" />

<add name="MyConn" connectionString="Data Source=C:\data.db;Version=3;"/>

, : -)

+1

Source: https://habr.com/ru/post/1726414/


All Articles