C# (CSharp) Microsoft.OData.Service.Sample.Northwind.Models SqlLoader Examples

Example #1

File: NorthwindContext.cs Project: chinadragon0515/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);

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

Example #2

File: NorthwindContext.cs Project: zengshine/Learn-Space

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