The ultimate solution to the real development problem of EF to SQLite

1. Version issue
2. VS Installation Issues
3. X64/x86 Publishing Issues

For the development of the problems encountered, through the method to solve:

1.sqlitehttp://system.data.sqlite.org/index.html/doc/trunk/www/downloads.wiki, my development environment is win8.1 x64 vs2010, Download sqlite-netfx40-static-binary-bundle-win32-2010-1.0.93.0.zip, do not download version 1.0.66.0. Regardless of the new and old version in the development of the problem. There are also issues when publishing. These issues will be addressed below.
2. It is best to use vs2010,vs2012 in the development of a lot of problems encountered in a short period of time can not be resolved. After installation, create a new edmx file directly using Dbfirst. However, if you have a NVARCHAR2 field in your database, an unrecognized exception will appear when the property is mapped.

3. The solution to this problem is to change the database field type to varchar, generate the edmx file, and then change to the NVARCHAR2 type. I created a new database through SQL and generated the file.
To the official technical staff is really no language.
X64/x86 issue is released.
Reference to the article Http://www.tuicool.com/articles/eAjeMb, but in practice, it takes a long time, simply cannot be achieved. Eventually swapped the version used in the article and tested it in different systems. Again to the official without words.

Related plugins download

Link: http://pan.baidu.com/s/1dDDypah Password: h715

Configuration file Code

    <System.Data>        <dbproviderfactories>            <!--ORACLE Drive Configuration -            <Removeinvariant= "Oracle.ManagedDataAccess.Client" />            <Addname= "Odp.net, Managed Driver"invariant= "Oracle.ManagedDataAccess.Client"Description= "Oracle Data Provider for. NET, Managed Driver"type= "Oracle.ManagedDataAccess.Client.OracleClientFactory, oracle.manageddataaccess, version=4.121.1.0, culture= Neutral, publickeytoken=89b483f429c47342 " />            <!--SQLite Drive Configuration -            <Removeinvariant= "System.Data.SQLite" />            <Addname= "SQLite Data Provider"invariant= "System.Data.SQLite"Description= ". Net Framework Data Provider for SQLite"type= "System.Data.SQLite.SQLiteFactory, System.Data.SQLite, version=1.0.90.0, Culture=neutral, publickeytoken= db937bc2d44ff139 " />        </dbproviderfactories>    </System.Data>    <StartupuseLegacyV2RuntimeActivationPolicy= "true">        <supportedruntimeversion= "v4.0"SKU=". netframework,version=v4.0 " />    </Startup>

The above is Oracle. Because the SQLite database is used dynamically in the system, it is not configured, but is created dynamically.