public static void QuoteTableAndColumns(Configuration configuration)
{
Iesi.Collections.Generic.ISet<string> reservedDb = GetReservedWords(configuration.GetDerivedProperties());
foreach (var cm in configuration.ClassMappings)
{
QuoteTable(cm.Table, reservedDb);
}
foreach (var cm in configuration.CollectionMappings)
{
QuoteTable(cm.Table, reservedDb);
}
}
private void ExecuteScriptFile(Configuration configuration, string scripFileName)
{
var file = new FileInfo(scripFileName);
string script = file.OpenText().ReadToEnd().Replace("GO", "");
var connectionProvider = ConnectionProviderFactory.NewConnectionProvider(configuration.GetDerivedProperties());
using (var conn = connectionProvider.GetConnection())
{
if (conn.State == ConnectionState.Closed)
{
conn.Open();
}
using (var command = conn.CreateCommand())
{
command.CommandText = script;
command.ExecuteNonQuery();
}
}
}