|
public static RunEmbeddedFile ( |
||
| connection | ||
| transaction | ||
| resourceFileName | string | |
| return | void | |
private void ReinstallStoredProcedures()
{
try
{
SortedDictionary <string, EmbeddedResourceName> storedProcedures = this.GetResourceNameUnderLocation(".Stored_Procedures");
foreach (EmbeddedResourceName ern in storedProcedures.Values)
{
try
{
SqlServers.RunEmbeddedFile(_connection, _transaction, ern.FullName);
}
catch (Exception ex)
{
System.Windows.Forms.MessageBox.Show("Sp Fail: " + ern.FullName);
throw;
}
}
}
catch (Exception ex)
{
throw;
}
}
private void UpgradeSchemaAndStaticData()
{
const string CREATE_SCHEMA_FILE = ".Create_Scripts.Generated.CreateSchema.sql";
const string STATIC_DATA_FILE = ".Create_Scripts.Generated.CreateData.sql";
const string UPGRADE_FOLDER = ".Upgrade_Scripts";
const string UPGRADE_GENERATED_FOLDER = ".Upgrade_Scripts.Generated.";
const string CREATE_FOLDER = ".Cre ate_Scripts";
try
{
SortedDictionary <string, EmbeddedResourceName> upgradeSchemaScripts = this.GetResourceNameUnderLocation(UPGRADE_GENERATED_FOLDER);
SortedDictionary <string, EmbeddedResourceName> sortByVersionScripts = new SortedDictionary <string, EmbeddedResourceName>(upgradeSchemaScripts, new UpgradeFileNameComparer());
//Run the generated upgrades
if (!_previousVersion.Equals(_def_Version))
{
foreach (EmbeddedResourceName ern in sortByVersionScripts.Values)
{
if (new Version(ern.FileName).CompareTo(_previousVersion) > 0)
{
SqlServers.RunEmbeddedFile(_connection, _transaction, ern.FullName);
}
}
}
//Run the create schema
SortedDictionary <string, EmbeddedResourceName> createSchemaScripts = this.GetResourceNameUnderLocation(CREATE_SCHEMA_FILE);
foreach (EmbeddedResourceName ern in createSchemaScripts.Values)
{
SqlServers.RunEmbeddedFile(_connection, _transaction, ern.FullName);
}
//Run the static data
createSchemaScripts = this.GetResourceNameUnderLocation(STATIC_DATA_FILE);
foreach (EmbeddedResourceName ern in createSchemaScripts.Values)
{
SqlServers.RunEmbeddedFile(_connection, _transaction, ern.FullName);
}
//Run all other scripts
SortedDictionary <string, EmbeddedResourceName> createDataScripts = this.GetResourceNameUnderLocation(CREATE_FOLDER);
foreach (EmbeddedResourceName ern in createDataScripts.Values)
{
//Make sure it is not the two defined scripts
if ((ern.AsmLocation != CREATE_SCHEMA_FILE) && (ern.AsmLocation != STATIC_DATA_FILE))
{
SqlServers.RunEmbeddedFile(_connection, _transaction, ern.FullName);
}
}
//Run the user-defined upgrades
List <string> excludePathList = new List <string>();
excludePathList.Add(UPGRADE_GENERATED_FOLDER);
upgradeSchemaScripts = this.GetResourceNameUnderLocation(UPGRADE_FOLDER, excludePathList);
sortByVersionScripts = new SortedDictionary <string, EmbeddedResourceName>(upgradeSchemaScripts, new UpgradeFileNameComparer());
if (_previousVersion != null)
{
foreach (EmbeddedResourceName ern in sortByVersionScripts.Values)
{
if (new Version(ern.FileName).CompareTo(_previousVersion) > 0)
{
SqlServers.RunEmbeddedFile(_connection, _transaction, ern.FullName);
}
}
}
}
catch (Exception ex)
{
throw;
}
}
