174.36.44.40,广新广告,景泰蓝
public static class DbProviderFactories { internal static readonly Dictionary<string, DbProviderFactory> Configs = new Dictionary<string, DbProviderFactory>(); static DbProviderFactories() { RegisterFactory("Microsoft.Data.Sqlite", SQLiteFactory.Instance); } public static DbProviderFactory GetFactory(string providerInvariantName) { if (Configs.ContainsKey(providerInvariantName)) { return Configs[providerInvariantName]; } return null; } public static void RegisterFactory(string providerInvariantName, DbProviderFactory factory) { if (Configs.ContainsKey(providerInvariantName)) { Configs[providerInvariantName] = factory; } else { Configs.Add(providerInvariantName, factory); } } public static IEnumerable<string> GetFactoryProviderNames() { return Configs.Keys.ToArray(); } }
<add name="PetaPocoConn" connectionString="Data Source=|DataDirectory|Demo.db"/>
var db=new Database(new SQLiteConnection(ConfigurationManager.ConnectionStrings["PetaPocoConn"].ConnectionString));
<system.data> <DbProviderFactories> <remove invariant="System.Data.SQLite"/> <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>
<connectionStrings> <add name="PetaPocoConn" connectionString="Data Source=|DataDirectory|Demo.db" providerName="System.Data.SQLite" /> </connectionStrings>
public static class DbScoure { public static Database SqliteDataBase() { var conn = ConfigurationManager.ConnectionStrings["PetaPocoConn"]; return new Database(conn.ConnectionString, conn.ProviderName); } } 调用方式: var db=DbScoure.SqliteDataBase();
如对本文有疑问,请在下面进行留言讨论,广大热心网友会与你互动!! 点击进行留言回复
asp.net搭建博客,使用BlogEngine.NET+MySql搭建博客
网友评论