public ISession GetSession() //todo configure, create sessionFactory, CreateSession
{
var firebirdConfiguration = new FirebirdConfiguration();
var configuration = Fluently.Configure()
.Database(firebirdConfiguration.ConnectionString(connectionString).ShowSql)
.Mappings(m => m.FluentMappings.AddFromAssemblyOf <UnitsMap>())
.Mappings(m => m.FluentMappings.AddFromAssemblyOf <RegionsMap>())
.Mappings(m => m.FluentMappings.AddFromAssemblyOf <DocumentsMap>())
.Mappings(m => m.FluentMappings.AddFromAssemblyOf <CompaniesMap>())
.Mappings(m => m.FluentMappings.AddFromAssemblyOf <FuelsMap>())
.Mappings(m => m.FluentMappings.AddFromAssemblyOf <PriceListsMap>())
.Mappings(m => m.FluentMappings.AddFromAssemblyOf <QuotationsMap>())
.Mappings(m => m.FluentMappings.AddFromAssemblyOf <QuotationTypesMap>())
.Mappings(m => m.FluentMappings.AddFromAssemblyOf <CurrencyMap>())
.Mappings(m => m.FluentMappings.AddFromAssemblyOf <CardGroupsMap>())
.Mappings(m => m.FluentMappings.AddFromAssemblyOf <DictionaryMap>())
.Mappings(m => m.FluentMappings.AddFromAssemblyOf <CardGroupsMap>())
.Mappings(m => m.FluentMappings.AddFromAssemblyOf <DictionaryTypeMap>())
.Mappings(m => m.FluentMappings.AddFromAssemblyOf <ForTableMap>())
.Mappings(m => m.FluentMappings.AddFromAssemblyOf <CardGroupTypesMap2>())
.Mappings(m => m.FluentMappings.AddFromAssemblyOf <StCardGroupTypesMap>())
.Mappings(m => m.FluentMappings.AddFromAssemblyOf <AnaliticsMap>())
.BuildConfiguration();
var sessionFactory = configuration.BuildSessionFactory();
var session = sessionFactory.OpenSession();
return(session);
}
private ISessionFactory CreateSessionFactory(string aConnectionString)
{
var fbc = new FirebirdConfiguration();
ISessionFactory sessionFactory = Fluently.Configure()
.Database(fbc.ConnectionString(aConnectionString).ShowSql())
//.Mappings(m => m.FluentMappings.AddFromAssemblyOf<App>())
.Mappings(m => m.FluentMappings.AddFromAssembly(Assembly.Load("Invent.Entities")))
.Diagnostics(x => x.Enable())
.BuildSessionFactory();
return sessionFactory;
}
public BootStrap()
{
_userName = "******";
_password = "******";
DbFile = "test.db";
ConnectionString = String.Format("ServerType=1;User={0};Password={1};Dialect=3;Database={2}", _userName, _password, DbFile);
//setup firebird configuration
firebird = new FirebirdConfiguration();
firebirdConfig = Fluently.Configure().Database(
firebird.ConnectionString(c => c
.Is(ConnectionString)));
}
public void CreateDB() //todo configure, create sessionFactory, CreateSession
{
var firebirdConfiguration = new FirebirdConfiguration();
var configuration = Fluently.Configure()
.Database(firebirdConfiguration.ConnectionString(connectionString).ShowSql)
.Mappings(m => m.FluentMappings.AddFromAssemblyOf <QuotationTypesMap>())
.Mappings(m => m.FluentMappings.AddFromAssemblyOf <RegionsMap>())
.Mappings(m => m.FluentMappings.AddFromAssemblyOf <DocumentsMap>())
.Mappings(m => m.FluentMappings.AddFromAssemblyOf <CompaniesMap>())
.Mappings(m => m.FluentMappings.AddFromAssemblyOf <FuelsMap>())
.Mappings(m => m.FluentMappings.AddFromAssemblyOf <PriceListsMap>())
.Mappings(m => m.FluentMappings.AddFromAssemblyOf <QuotationsMap>())
.BuildConfiguration();
var exporter = new SchemaUpdate(configuration);
exporter.Execute(true, true);
}
public void SetUp()
{
_config = new FirebirdConfiguration();
_props = _config.ToProperties();
}
/// <summary>
/// Configura uma SessionFactory de acordo com o banco de dados configurado no arquivo RegLog.config
/// </summary>
/// <returns></returns>
public static ISessionFactory ObterSessionFactory()
{
ISessionFactory factory = null;
ConfigConnection();
switch (_database)
{
case 0:
factory = Fluently.Configure().Database(
SQLiteConfiguration.Standard.UsingFile(_connection).ShowSql()
).Mappings(c => c.FluentMappings.AddFromAssemblyOf<LogModel>())
.ExposeConfiguration(config => new SchemaExport(config).Create(false, true))
.BuildSessionFactory();
break;
case 1:
factory = Fluently.Configure().Database(
MsSqlConfiguration.MsSql2008.ConnectionString(_connection).ShowSql()
).Mappings(c => c.FluentMappings.AddFromAssemblyOf<LogModel>())
.ExposeConfiguration(config => new SchemaExport(config).Create(false, true))
.BuildSessionFactory();
break;
case 11:
factory = Fluently.Configure().Database(
MsSqlConfiguration.MsSql2012.ConnectionString(_connection).ShowSql()
).Mappings(c => c.FluentMappings.AddFromAssemblyOf<LogModel>())
.ExposeConfiguration(config => new SchemaExport(config).Create(false, true))
.BuildSessionFactory();
break;
case 19:
factory = Fluently.Configure().Database(
MsSqlCeConfiguration.Standard.ConnectionString(_connection).ShowSql()
).Mappings(c => c.FluentMappings.AddFromAssemblyOf<LogModel>())
.ExposeConfiguration(config => new SchemaExport(config).Create(false, true))
.BuildSessionFactory();
break;
case 2:
factory = Fluently.Configure().Database(
MySQLConfiguration.Standard.ConnectionString(_connection).ShowSql()
).Mappings(c => c.FluentMappings.AddFromAssemblyOf<LogModel>())
.ExposeConfiguration(BuildSchema)
//.ExposeConfiguration(config => new SchemaExport(config).Create(false, true))
.BuildSessionFactory();
break;
case 3:
factory = Fluently.Configure().Database(
PostgreSQLConfiguration.Standard.ConnectionString(_connection).ShowSql()
).Mappings(c => c.FluentMappings.AddFromAssemblyOf<LogModel>())
.ExposeConfiguration(config => new SchemaExport(config).Create(false, true))
.BuildSessionFactory();
break;
case 4:
factory = Fluently.Configure().Database(
DB2Configuration.Standard.ConnectionString(_connection).ShowSql()
).Mappings(c => c.FluentMappings.AddFromAssemblyOf<LogModel>())
.ExposeConfiguration(config => new SchemaExport(config).Create(false, true))
.BuildSessionFactory();
break;
case 5:
FirebirdConfiguration cfg = new FirebirdConfiguration()
.ConnectionString(_connection)
.AdoNetBatchSize(100);
factory = Fluently.Configure().Database(cfg).Mappings(c => c.FluentMappings.AddFromAssemblyOf<LogModel>())
.ExposeConfiguration(config => new SchemaExport(config).Create(false, true))
.BuildSessionFactory();
break;
case 6:
factory = Fluently.Configure().Database(
OracleClientConfiguration.Oracle9.ConnectionString(_connection).ShowSql()
).Mappings(c => c.FluentMappings.AddFromAssemblyOf<LogModel>())
.ExposeConfiguration(config => new SchemaExport(config).Create(false, true))
.BuildSessionFactory();
break;
case 61:
factory = Fluently.Configure().Database(
OracleClientConfiguration.Oracle10.ConnectionString(_connection).ShowSql()
).Mappings(c => c.FluentMappings.AddFromAssemblyOf<LogModel>())
.ExposeConfiguration(config => new SchemaExport(config).Create(false, true))
.BuildSessionFactory();
break;
}
return factory;
}
public void SetUp()
{
_config = new FirebirdConfiguration();
_props = _config.ToProperties();
}
