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(); } }