EF动态设置SQLite的连接串
/// <summary>
/// 自定义连接串
/// </summary>
/// <returns></returns>
public static string EFConnctionString { get; set; }
public static DbConnection GetEFConnctionString()
{
return new SQLiteConnection() { ConnectionString = EFConnctionString };
}
public BackupsDataContext()
: base(GetEFConnctionString(), true)
{
}
//设置连接串
BackupsDataContext.EFConnctionString = string.Format("data source={0}", "数据库路径");
//连接数据库
using (var db = new BackupsDataContext())
{
db.Database.ExecuteSqlCommand("Delete from [表]");
db.SaveChanges();
}