static void Main(string[] args) { //Sql Authentication //ServerConnection conn = new ServerConnection(".", "sa", "banana"); //Windows Authentication ServerConnection conn = new ServerConnection(".", "sa", "banana"); Database db =null; List<CustomTable> dbCustomTables= new List<CustomTable>(); //try //{ Server srv = new Server(conn); Console.WriteLine("Server: " + srv.Name); Console.WriteLine("Edition: " + srv.Information.Edition); foreach (Database tempdb in srv.Databases) { Console.WriteLine(tempdb.Name); } while (db==null) { Console.Write("Enter db name you want to generate its' code: "); string dbName = Console.ReadLine(); db = srv.Databases[dbName]; if (db == null) { Console.WriteLine("invalid db name "); } } //ProjectBuilder.Init( ProjectBuilder.Build(db); //CreateDatabase(srv, "testikoSMO", "C:\\"); // Database dbIndexers = srv.Databases[5]; //Table indexers =dbIndexers.Tables["Indexers"]; //ColumnCollection cl = indexers.Columns; //Database dbIndexers = (new System.Linq.SystemCore_EnumerableDebugView(srv.Databases[5].Tables)).Items[0] //BackupDatabase(srv, "Indexers", @"C:\Test\Indexers.bak"); /* foreach (Database db in srv.Databases) { Console.WriteLine(db.Name); foreach (FileGroup fg in db.FileGroups) { Console.WriteLine(" " + fg.Name); foreach (DataFile df in fg.Files) { Console.WriteLine(" " + df.Name + " " + df.FileName); } } foreach (Property prop in db.Properties) { Console.WriteLine(prop.Name + " " + prop.Value); } } */ conn.Disconnect(); //} //catch (Exception err) //{ // Console.WriteLine(err.Message); //} }
static void Main(string[] args) { //Sql Authentication //ServerConnection conn = new ServerConnection(".", "sa", "banana"); //Windows Authentication string DatabaseServer = ConfigurationSettings.AppSettings["DatabaseServer"]; string DatabaseUser = ConfigurationSettings.AppSettings["DatabaseUser"]; string DatabasePasswoed = ConfigurationSettings.AppSettings["DatabasePasswoed"]; ServerConnection conn = new ServerConnection(DatabaseServer, DatabaseUser, DatabasePasswoed); Database db =null; List<CustomTable> dbCustomTables= new List<CustomTable>(); //try //{ Server srv = new Server(conn); Console.WriteLine("Server: " + srv.Name); //Console.WriteLine("Edition: " + srv.Information.Edition); foreach (Database tempdb in srv.Databases) { Console.WriteLine(tempdb.Name); } while (db==null) { Console.Write("Enter db name you want to generate its' code: "); string dbName = Console.ReadLine(); db = srv.Databases[dbName]; /*foreach (StoredProcedure sp in db.StoredProcedures) { Console.WriteLine("Name:{0}",sp.Name); foreach (StoredProcedureParameter p in sp.Parameters) { Console.WriteLine("Name:{0}", p.Name); Console.WriteLine("DataType:{0}", p.DataType); Console.WriteLine("IsOutputParameter:{0}", p.IsOutputParameter); Console.WriteLine("IsReadOnly:{0}", p.IsReadOnly); Console.WriteLine("IsCursorParameter:{0}", p.IsCursorParameter); Console.WriteLine("ID:{0}", p.ID); Console.WriteLine("DefaultValue:{0}", p.DefaultValue); Console.WriteLine("----------------------------------------------"); //sp.ExecuteWithModes(SqlExecutionModes.; } // Console.WriteLine("Enter for Next"); Console.ReadLine(); Console.WriteLine("Name:{0}", sp.Parameters); }*/ if (db == null) { Console.WriteLine("invalid db name "); } } //ProjectBuilder.Init( ProjectBuilder.Build(db); //CreateDatabase(srv, "testikoSMO", "C:\\"); // Database dbIndexers = srv.Databases[5]; //Table indexers =dbIndexers.Tables["Indexers"]; //ColumnCollection cl = indexers.Columns; //Database dbIndexers = (new System.Linq.SystemCore_EnumerableDebugView(srv.Databases[5].Tables)).Items[0] //BackupDatabase(srv, "Indexers", @"C:\Test\Indexers.bak"); /* foreach (Database db in srv.Databases) { Console.WriteLine(db.Name); foreach (FileGroup fg in db.FileGroups) { Console.WriteLine(" " + fg.Name); foreach (DataFile df in fg.Files) { Console.WriteLine(" " + df.Name + " " + df.FileName); } } foreach (Property prop in db.Properties) { Console.WriteLine(prop.Name + " " + prop.Value); } } */ conn.Disconnect(); //} //catch (Exception err) //{ // Console.WriteLine(err.Message); //} }