C# (CSharp) AdventureWorksLTSample.Models SqlLoader Exemples

Exemple #1

Fichier : AdventureWorksContext.cs Projet : nickgoodrow/ODataSamples

 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);
 }

Exemple #2

        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);
        }

Exemple #3

Fichier : AdventureWorksContext.cs Projet : chinadragon0515/ODataSamples

        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);
        }

Exemple #4

Fichier : AdventureWorksContext.cs Projet : EricCote/WebApi2

        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);
        }