C# (CSharp) Microsoft.Restier.Samples.Northwind.Models SqlLoader Examples

Example #1

File: NorthwindContext.cs Project: adestis-mh/RESTier

 private static void LoadDataSource()
 {
     var dbPath = SqlLoader.GetDatabaseDirectory(null);
     var loader = new SqlLoader();
     loader.SetDatabaseEngine("(localdb)\\MSSQLLocalDB");
     loader.AddScript("instnwdb.sql");
     loader.AddScriptArgument("SqlSamplesDatabasePath", dbPath);
     loader.Execute(dbPath);
 }

Example #2

File: NorthwindContext.cs Project: anandnooli79/RESTier

        private static void LoadDataSource()
        {
            var dbPath = SqlLoader.GetDatabaseDirectory(null);
            var loader = new SqlLoader();

            loader.SetDatabaseEngine("(localdb)\\MSSQLLocalDB");
            loader.AddScript("instnwdb.sql");
            loader.AddScriptArgument("SqlSamplesDatabasePath", dbPath);
            loader.Execute(dbPath);
        }

Example #3

        private static void LoadDataSource()
        {
            var dbPath = SqlLoader.GetDatabaseDirectory(null);
            var loader = new SqlLoader();

            loader.SetDatabaseEngine("(localdb)\\MSSQLLocalDB");
            loader.AddScript("instnwdb.sql");
            loader.AddScriptArgument("SqlSamplesDatabasePath", dbPath);

            // Length of database name in SQLServer cannot exceed 128.
            var dbNamePrefix = dbPath;

            if (dbNamePrefix.Length > 100)
            {
                dbNamePrefix = dbNamePrefix.Substring(dbNamePrefix.Length - 100);
                dbNamePrefix = dbNamePrefix.Substring(dbNamePrefix.IndexOf('\\') + 1);
            }

            loader.AddScriptArgument("SqlDBNamePrefix", dbNamePrefix);
            loader.Execute(dbPath);
        }