public void Dispose() { if (_fdb != null) { _fdb.Dispose(); _fdb = null; } }
static int Main(string[] args) { string server = "", database = "", uid = "", pwd = "", dataset = "", imageSpace = "database"; string connectionString = ""; bool delExisting = true; bool imagedataset = false; for (int i = 0; i < args.Length; i++) { if (args[i] == "-server") { server = args[++i]; } if (args[i] == "-uid") { uid = args[++i]; } if (args[i] == "-pwd") { pwd = args[++i]; } if (args[i] == "-database") { database = args[++i]; } if (args[i] == "-ds") { dataset = args[++i]; } if (args[i] == "-imagedataset") { imagedataset = true; } if (args[i] == "-imagespace") { imageSpace = args[++i]; } if (args[i] == "-connectionstring") { connectionString = args[++i]; } } if (((server == "" && database == "") && connectionString == "") || dataset == "") { Console.WriteLine("USAGE:"); Console.WriteLine("gView.Cmd.CreateSqlFDBDataset -server <Filename> -database <Database> OR -connectionstring <ConnectionString>"); Console.WriteLine(" -ds <Datasetname>"); Console.WriteLine(" [-uid <User> -pwd <Password> -imagedataset -imagespace <Image Space Directory (Database)>]"); return(1); } try { if (connectionString == "") { connectionString = "server=" + server + ";database=" + database; if (uid != "") { connectionString += ";uid=" + uid + ";pwd=" + pwd; } else { connectionString += ";Trusted_Connection=True"; } } SqlFDB fdb = new SqlFDB(); if (!fdb.Open(connectionString)) { Console.WriteLine("\n\nERROR: " + fdb.lastErrorMsg); return(1); } //SpatialReference sRef = new SpatialReference(); ISpatialIndexDef sIndexDef = new gViewSpatialIndexDef(); if (imagedataset) { if (fdb.CreateImageDataset(dataset, null, sIndexDef, imageSpace, null) < 1) { fdb.Dispose(); Console.WriteLine("\n\nERROR: " + fdb.lastErrorMsg); return(1); } } else { if (fdb.CreateDataset(dataset, null, sIndexDef) < 1) { fdb.Dispose(); Console.WriteLine("\n\nERROR: " + fdb.lastErrorMsg); return(1); } } fdb.Dispose(); Console.WriteLine(server + @"\" + database + ": Dataset " + dataset + " created..."); return(0); } catch (Exception ex) { Console.WriteLine("\n\nERROR: " + ex.Message); return(1); } }
static int Main(string[] args) { string server = "", uid = "", pwd = "", database = "", mdf = String.Empty; UserData userData = new UserData(); for (int i = 0; i < args.Length - 1; i++) { if (args[i] == "-server") { server = args[++i]; } if (args[i] == "-uid") { uid = args[++i]; } if (args[i] == "-pwd") { pwd = args[++i]; } if (args[i] == "-database") { database = args[++i]; } if (args[i] == "-mdf") { mdf = args[++i]; } if (args[i].StartsWith("-_")) { userData.SetUserData(args[i].Substring(2, args[i].Length - 2), args[++i]); } } if (server == "" || database == "") { Console.WriteLine("USAGE:"); Console.WriteLine("gView.Cmd.CreateSqlFDB -server <SQL Server Instance>"); Console.WriteLine(" -database <Database Name>"); Console.WriteLine(" [-uid <User>]"); Console.WriteLine(" [-pwd <Password>]"); Console.WriteLine(" [-mdf <mdf_file_path>"); Console.WriteLine(" [-_Parametername <parameter>]"); Console.WriteLine("Example:"); Console.WriteLine("CreateSqlFDB -server localhost -database NEW_FDB -_filename c:\\myDatabase.mdf -_size 300 -_filegrowth 50"); return(1); } // Path setzen, damit in fdb.Create die createdatabase.sql gefunden wird... /* * if (SystemVariables.RegistryApplicationDirectory != "") * { * SystemVariables.ApplicationDirectory = SystemVariables.RegistryApplicationDirectory; * } */ string connectionString = "server=" + server; if (uid != "") { connectionString += ";uid=" + uid + ";pwd=" + pwd; } else { connectionString += ";Trusted_Connection=True"; } SqlFDB fdb = new SqlFDB(); if (!fdb.Open(connectionString)) { Console.WriteLine("ERROR :" + fdb.lastErrorMsg); fdb.Dispose(); return(1); } if (!String.IsNullOrEmpty(mdf)) { if (!fdb.Create(database, mdf)) { Console.WriteLine("ERROR :" + fdb.lastErrorMsg); fdb.Dispose(); return(1); } } else { if (userData.UserDataTypes.Length > 0) { Console.WriteLine("CREATE DATABASE " + database + " ON PRIMARY (NAME=" + database + ","); foreach (string type in userData.UserDataTypes) { Console.WriteLine(type + "="); if (type.ToLower() == "filename") { Console.WriteLine("'" + userData.GetUserData(type) + "'"); } else { Console.WriteLine(userData.GetUserData(type)); } } Console.WriteLine(")"); } if (!fdb.Create(database, userData)) { Console.WriteLine("ERROR :" + fdb.lastErrorMsg); fdb.Dispose(); return(1); } } fdb.Dispose(); Console.WriteLine("...done"); return(0); }