没有App.config的SQLite实体框架 [英] SQLite Entity Framework without App.config
问题描述
有必要使用SQLite实体框架数据库第一种方法来实现3d方应用程序插件。我搜索了所有的互联网，包括添加没有App.Config的DbProviderFactory ，使用实体框架6和SQLite 等问题。我试图以不同的方式和组合使用它们，但没有任何帮助：
It is necessary to use the SQLite Entity Framework Database-first approach for the 3d-party application plugin. I searched all the Internet, including Add a DbProviderFactory without an App.Config, Problems using Entity Framework 6 and SQLite and many other. I have tried to use them all in different ways and combinations, but nothing helps:
类型
的未处理的异常System.Data.Entity.Core.MetadataException'发生在mscorlib.dll中
附加信息：指定的模式无效错误：
AutosuggestModel.ssdl（2,2）：错误0152：没有实体框架提供者
为ADO.NET提供程序找到不变名称
'System.Data.SQLite.EF6'。确保提供程序已注册在应用程序配置文件的
'entityFramework'部分。
"An unhandled exception of type 'System.Data.Entity.Core.MetadataException' occurred in mscorlib.dll. Additional information: Schema specified is not valid. Errors: AutosuggestModel.ssdl (2,2): error 0152: No Entity Framework provider found for the ADO.NET provider with invariant name 'System.Data.SQLite.EF6'. Make sure the provider is registered in the 'entityFramework' section of the application config file."
解决方案中有一个测试控制台应用程序。有了这个最小的App.config，它的工作原理是：
There is a test console application in the solution. With this minimal App.config it works:
<?xml version="1.0" encoding="utf-8"?>
<configuration>
<configSections>
<!-- For more information on Entity Framework configuration, visit http://go.microsoft.com/fwlink/?LinkID=237468 -->
<section name="entityFramework" type="System.Data.Entity.Internal.ConfigFile.EntityFrameworkSection, EntityFramework, Version=6.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" requirePermission="false" />
</configSections>
<entityFramework>
<providers>
<provider invariantName="System.Data.SQLite.EF6" type="System.Data.SQLite.EF6.SQLiteProviderServices, System.Data.SQLite.EF6" />
</providers>
</entityFramework>
<system.data>
<DbProviderFactories>
<add name="SQLite Data Provider" invariant="System.Data.SQLite" description=".NET Framework Data Provider for SQLite" type="System.Data.SQLite.SQLiteFactory, System.Data.SQLite" />
</DbProviderFactories>
</system.data>
</configuration>
连接字符串已经在代码中实现了。二手包是：
The connection string has already implemented in the code. Used packages are:
<?xml version="1.0" encoding="utf-8"?>
<packages>
<package id="EntityFramework" version="6.1.3" targetFramework="net452" />
<package id="System.Data.SQLite" version="1.0.98.1" targetFramework="net452" />
<package id="System.Data.SQLite.Core" version="1.0.98.1" targetFramework="net452" />
<package id="System.Data.SQLite.EF6" version="1.0.98.1" targetFramework="net452" />
<package id="System.Data.SQLite.Linq" version="1.0.98.1" targetFramework="net452" />
</packages>
请提供所有必需的代码，并指定要插入的位置。感谢提前。
Please, give all the required code and specify where to insert it. Thanks in advance.
推荐答案
以下是一个示例代码，说明如何实现目标。
Here is a sample code that illustrates how to achieve the goal.
namespace SqliteEFNoConfig
{
using System.Configuration;
using System.Data;
using System.Data.Common;
using System.Data.Entity;
using System.Data.Entity.Core.Common;
using System.Data.SQLite;
using System.Data.SQLite.EF6;
using System.Linq;
internal class Program
{
private static void Main()
{
// EF manages the connection via the DbContext instantiation
// connection string is set in config
// Use this code if you want to use a config file
// with only the connection string
//using (var model = new Model1())
//{
// var dbSetProperty = model.dbSetProperty.ToList();
//}
// Alternative method:
// Use this code if you don't want to use a config file
// You will also need to use the override constructor shown below,
// in your EF Model class
var connectionString = @"data source = {PathToSqliteDB}";
using (var connection = new SQLiteConnection(connectionString))
{
using (var model = new Model1(connection))
{
var dbSetProperty = model.dbSetProperty.ToList();
}
}
}
}
class SqliteDbConfiguration : DbConfiguration
{
public SqliteDbConfiguration()
{
string assemblyName = typeof (SQLiteProviderFactory).Assembly.GetName().Name;
RegisterDbProviderFactories(assemblyName );
SetProviderFactory(assemblyName, SQLiteFactory.Instance);
SetProviderFactory(assemblyName, SQLiteProviderFactory.Instance);
SetProviderServices(assemblyName,
(DbProviderServices) SQLiteProviderFactory.Instance.GetService(
typeof (DbProviderServices)));
}
static void RegisterDbProviderFactories(string assemblyName)
{
var dataSet = ConfigurationManager.GetSection("system.data") as DataSet;
if (dataSet != null)
{
var dbProviderFactoriesDataTable = dataSet.Tables.OfType<DataTable>()
.First(x => x.TableName == typeof (DbProviderFactories).Name);
var dataRow = dbProviderFactoriesDataTable.Rows.OfType<DataRow>()
.FirstOrDefault(x => x.ItemArray[2].ToString() == assemblyName);
if (dataRow != null)
dbProviderFactoriesDataTable.Rows.Remove(dataRow);
dbProviderFactoriesDataTable.Rows.Add(
"SQLite Data Provider (Entity Framework 6)",
".NET Framework Data Provider for SQLite (Entity Framework 6)",
assemblyName,
typeof (SQLiteProviderFactory).AssemblyQualifiedName
);
}
}
}
}
您决定不在配置文件中添加连接字符串，则需要在EF模型中添加以下构造函数。
In case you decide to not add a connection string in the config file then you need to add the following constructor in the EF model.
public Model1(DbConnection connection)
: base(connection, true)
{
}
注意：上面的代码只是一个关于如何实现目标的示例，您将不得不根据您的需要进行调整。假设您使用EF Code First方法提供上述代码。
Notice: The above code is just a sample on how to achieve the goal and you will have to adjust it accordingly to your needs. The above code is provided assuming you are using EF Code First approach.
这篇关于没有App.config的SQLite实体框架的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
