/// <summary>
/// Bygger upp alla tabeller och vyer i en databas i enlighet med den senaste versionen. Databasen måste finnas innan den här funktionen används.
/// </summary>
public void BuildDatabase()
{
DropAllTablesInDatabase();
DatabaseSchema database = new DatabaseSchema(DatabaseDefinition.GetDatabaseXmlDefinition(DatabaseDefinition.DatabaseVersion));
string[] sqls = database.GenerateSqlCreate();
foreach (string sql in sqls)
{
Connection.Execute(sql);
}
// Write the database table
string startSql = "insert into EasyBaseSystems values (" + (int)EasyBase.Classes.EasyBaseSystemNo.CurrentApplicationNo + ", " + DatabaseDefinition.DatabaseVersion + ", " + DatabaseDefinition.DatabaseVersion + ")";
Connection.Insert(startSql);
InitDatabaseOnCreate();
}
public static string[] GetCreateSqlScript()
{
DatabaseSchema database = new DatabaseSchema(GetDatabaseDefinitionXml());
return(database.GenerateSqlCreate());
}