C#自動註冊sqlite ado.net資料庫驅動 及 自訂連接字串

vista或以上系統必須取得系統管理員許可權執行以下代碼。sqlite.net使用了1.0.66.0，支援ado.net EF資料模型，：http://sourceforge.net/projects/sqlite-dotnet2/files/SQLite%20for%20ADO.NET%202.0/

部署時必須確保System.Data.SQLite.dll和System.Data.SQLite.Linq.dll都在項目的輸入目錄。即你的程式exe檔案所在目錄。

using System.Configuration;
using System.Xml.Linq;
using System.EnterpriseServices.Internal;

var d = ConfigurationManager.OpenMachineConfiguration().FilePath;
XElement xe = XElement.Load(d);
var dd = xe.Element("system.data").Element("DbProviderFactories").Elements("add");
if (dd.Where(md => md.Attribute("name").Value.Equals("SQLite Data Provider")).Count() == 0)
{
    Publish objPub = new Publish();
    objPub.GacRemove("System.Data.SQLite.dll");
    objPub.GacRemove("System.Data.SQLite.Linq.dll");
    objPub.GacInstall("System.Data.SQLite.dll");
    objPub.GacInstall("System.Data.SQLite.Linq.dll");

    xe.Element("system.data").Element("DbProviderFactories").Add(new XElement("add",
        new XAttribute("name", "SQLite Data Provider"), new XAttribute("invariant",
        "System.Data.SQLite"), new XAttribute("description", ".Net Framework Data Provider for SQLite"),
        new XAttribute("type", "System.Data.SQLite.SQLiteFactory, System.Data.SQLite, Version=1.0.66.0, Culture=neutral, PublicKeyToken=db937bc2d44ff139")
        ));
    xe.Save(d);
}

以下順便提供一個自訂ado.net EF的自訂資料庫連接方法：

public EntityConnection GetEntityConnection()
{
    EntityConnectionStringBuilder ecsb = new EntityConnectionStringBuilder();
    ecsb.Metadata = string.Format(@"res://*/{0}.csdl|res://*/{0}.ssdl|res://*/{0}.msl", "Model1");
    ecsb.Provider = "System.Data.SQLite";
    ecsb.ProviderConnectionString = @"data source=data.db;Password=admin";
    EntityConnection ec = new EntityConnection(ecsb.ToString());
    return ec;
}

使用時：

dataEntities de = new dataEntities(GetEntityConnection());
dataGrid1.ItemsSource = de.userTable;