public static void ResetDataSource() { var dbPath = SqlLoader.GetDatabaseDirectory("AdventureWorks_2012_LT_Script"); var loader = new SqlLoader(); loader.AddDatabaseEngine("(localdb)\\v11.0"); loader.AddScript("instawltdb.sql"); loader.AddScriptArgument("SqlSamplesDatabasePath", dbPath); loader.AddScriptArgument("SqlSamplesSourceDataPath", dbPath); loader.Execute(dbPath); }
public static void ResetDataSource() { // This is a folder in App_Data folder var dbPath = SqlLoader.GetDatabaseDirectory("AdventureWorks_2012_LT_Script"); var loader = new SqlLoader(); loader.SetDatabaseEngine("(localdb)\\MSSQLLocalDB"); // It is in folder App_Data/AdventureWorks_2012_LT_Script folder loader.AddScript("instawltdb.sql"); loader.AddScriptArgument("SqlSamplesDatabasePath", dbPath); loader.AddScriptArgument("SqlSamplesSourceDataPath", dbPath); loader.Execute(dbPath); }