private static void RunScriptGenerator(string server, string databaseName, string rootPath, string schemaFolder, string dropFilesFolder
, string installScriptFileName, string dropObjectsFileName)
{
string connectionString = string.Format("Server={0};Database={1};Trusted_Connection=True"
, server
, databaseName);
using (SqlConnection c = new System.Data.SqlClient.SqlConnection(connectionString))
{
try { c.Open(); }
catch (Exception e)
{
System.Console.WriteLine(string.Format(ERRORS, "Unable to run scriptgen. Reason: " + e.Message));
return;
}
finally
{
if (c.State == System.Data.ConnectionState.Open)
{
c.Close();
}
}
}
StringBuilder errors = new StringBuilder();
DatabaseScriptGenerator databaseScriptGenerator = new DatabaseScriptGenerator();
databaseScriptGenerator.NewMessage += new EventHandler <MessageEventArgs>(databaseScriptGenerator_NewMessage);
databaseScriptGenerator.Generate(connectionString
, rootPath.TrimEnd('\\')
, rootPath.TrimEnd('\\') + @"\" + schemaFolder.Trim('\\')
, rootPath.TrimEnd('\\') + @"\" + dropFilesFolder.Trim('\\')
, installScriptFileName
, dropObjectsFileName
, errors);
if (errors.Length == 0)
{
System.Console.WriteLine(
@"
SUCCESS
Yout have successfully created all database scripts. Press ENTER");
}
else
{
System.Console.WriteLine(
@"
ERRORS OCCURED
Scripts were generated but the following errors occurred during generation:
" + errors.ToString() + @"
Press ENTER");
}
System.Console.ReadLine();
}
public void CreateFromEntityTest()
{
var result = DatabaseScriptGenerator.CreateScriptFromEntityType(
typeof(StdContact),
"Contacts");
Assert.IsFalse(string.IsNullOrEmpty(result));
}
