public DatabaseFactory(IConnectionStringProvider connectionStringProvider, IMappingProvider mappingProvider)
{
DatabaseFactoryConfigOptions options = new DatabaseFactoryConfigOptions();
var connectionString = connectionStringProvider.GetConnectionString();
var mappings = mappingProvider.GetMappings();
options.Database = () => new LoggingDatabase(connectionString);
options.PocoDataFactory = FluentMappingConfiguration.Configure(mappings);
databaseFactory = new NPoco.DatabaseFactory(options);
}
static void Main(string[] args)
{
DatabaseFactoryConfigOptions options = new DatabaseFactoryConfigOptions();
options.Database = () => new NPoco.Database("host=marspostgresql.postgres.database.azure.com;user id=middleware_user@marspostgresql;password=I @m a 1itt1e t@apot;database=marsworxpoc;ApplicationName=Marsworx Middleware", DatabaseType.PostgreSQL, Npgsql.NpgsqlFactory.Instance);//
options.PocoDataFactory = FluentMappingConfiguration.Configure(
new ParentMap()
, new ChildMap()
, new OtherChildMap()
, new IntermediateMap()
);
var databaseFactory = new DatabaseFactory(options);
using (var db = databaseFactory.GetDatabase()) {
var result = db.Query <Parent>().Count();
}
}
