public static Configuration GetConfiguration(
ShowSqlSetting showSqlSetting = ShowSqlSetting.DontShowSql,
ExportSchemaSetting exportSchemaSetting = ExportSchemaSetting.DontExport,
string connectionStringName = "DbConfiguration")
{
return(Fluently.Configure()
.Database(GetDatabaseConfiguration(connectionStringName, showSqlSetting))
.ExposeConfiguration(cfg => AddConfiguration(cfg, exportSchemaSetting, showSqlSetting))
.Mappings(AddMappings)
.BuildConfiguration());
}
public static Configuration GetConfiguration(
ShowSqlSetting showSqlSetting = ShowSqlSetting.DontShowSql,
ExportSchemaSetting exportSchemaSetting = ExportSchemaSetting.DontExport,
string connectionStringName = "DbConfiguration")
{
return Fluently.Configure()
.Database(GetDatabaseConfiguration(connectionStringName, showSqlSetting))
.ExposeConfiguration(cfg => AddConfiguration(cfg, exportSchemaSetting, showSqlSetting))
.Mappings(AddMappings)
.BuildConfiguration();
}
private static IPersistenceConfigurer GetDatabaseConfiguration(string connectionStringName, ShowSqlSetting showSqlSetting)
{
var dbConfig = MsSqlConfiguration.MsSql2008;
// We're using geography, you can also use geometry
//dbConfig.Dialect<MsSql2008GeometryDialect>();
dbConfig.Dialect<MsSql2008GeographyDialect>();
dbConfig.ConnectionString(s => s.FromConnectionStringWithKey(connectionStringName));
if (showSqlSetting == ShowSqlSetting.ShowSql)
dbConfig.ShowSql();
return dbConfig;
}
private static IPersistenceConfigurer GetDatabaseConfiguration(string connectionStringName, ShowSqlSetting showSqlSetting)
{
var dbConfig = MsSqlConfiguration.MsSql2008;
// We're using geography, you can also use geometry
//dbConfig.Dialect<MsSql2008GeometryDialect>();
dbConfig.Dialect <MsSql2008GeographyDialect>();
dbConfig.ConnectionString(s => s.FromConnectionStringWithKey(connectionStringName));
if (showSqlSetting == ShowSqlSetting.ShowSql)
{
dbConfig.ShowSql();
}
return(dbConfig);
}
private static void AddConfiguration(Configuration cfg, ExportSchemaSetting exportSchemaSetting, ShowSqlSetting showSqlSetting)
{
var export = exportSchemaSetting == ExportSchemaSetting.Export;
var script = showSqlSetting == ShowSqlSetting.ShowSql;
new SchemaExport(cfg).Create(script && export, export);
}
private static void AddConfiguration(Configuration cfg, ExportSchemaSetting exportSchemaSetting, ShowSqlSetting showSqlSetting)
{
var export = exportSchemaSetting == ExportSchemaSetting.Export;
var script = showSqlSetting == ShowSqlSetting.ShowSql;
new SchemaExport(cfg).Create(script && export, export);
}
