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