public static void Setup() { var fluentConfig = FluentMappingConfiguration.Configure(); PayDbFactory = DatabaseFactory.Config(x => x.UsingDatabase(() => new Database("DefaultConnection")) .WithFluentConfig(fluentConfig)); }
public static DatabaseFactory Config(Action<DatabaseFactoryConfig> optionsAction) { var options = new DatabaseFactoryConfigOptions(); var databaseFactoryConfig = new DatabaseFactoryConfig(options); optionsAction(databaseFactoryConfig); var dbFactory = new DatabaseFactory(options); return dbFactory; }
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); }
public static void Init() { DbFact = new DatabaseFactory(); var config = FluentMappingConfiguration.Scan(x => { x.TheCallingAssembly(); x.WithSmartConventions(true); x.Columns.IgnoreWhere(y => y.GetCustomAttributes(typeof(IgnoreAttribute), true).Any()); x.OverrideMappingsWith(new OverrideNPoco()); }); DbFact.Config().WithFluentConfig(config); }
public static void Setup(string connection) { var conventions = FluentMappingConfiguration.Scan(scanner => { scanner.Assembly(typeof(Product).Assembly); scanner.IncludeTypes(x => x.Namespace.StartsWith(typeof(Product).Namespace)); scanner.TablesNamed(x => Inflector.MakePlural(x.Name)); scanner.PrimaryKeysNamed(x => "Id"); scanner.OverrideMappingsWith(new IMap[] { new ProductMap(), new CategoryMap(), new LineItemMap(), new CartMap()}); }); DbFactory = DatabaseFactory.Config(x => { x.UsingDatabase(() => new Database(connection)); x.WithFluentConfig(conventions); }); }
public IEnumerable<TesteDTO> GetAll() { DatabaseFactoryConfigOptions options = new DatabaseFactoryConfigOptions(); options.Database = () => new Database("ApplicationConnectionString"); //options.PocoDataFactory = FluentMappingConfiguration.Configure(new PersonMap(), new AddressMap()); databaseFactory = new DatabaseFactory(options); using (var db = databaseFactory.GetDatabase()) { using (var tran = db.GetTransaction()) { var t = db.Fetch<TesteDTO>("SELECT \"Id\", \"Name\" FROM \"Teste\"; "); return null; } } //SqlConnection connection = new SqlConnection(ConfigurationManager.ConnectionStrings["DefaultConnection"].ToString()); ///"Server=127.0.0.1;Port=5432;User Id=postgres;Password=pa$$w0rd;Database=Admin;" //NpgsqlConnection connection = new NpgsqlConnection("Server=127.0.0.1;Port=5432;Database=Admin;User Id=admin;Password=admin"); //NpgsqlConnection conn = new NpgsqlConnection(ConfigurationManager.ConnectionStrings["DefaultConnection"].ToString()); //var query = "SELECT Id, Name FROM public.Teste"; //NpgsqlCommand cmd = new NpgsqlCommand(query, conn); //IDatabase db = new Database(conn); //var t = db.Fetch<TesteDTO>(); //return t; //using (var conn = new NpgsqlConnection("Host=.;Username=postgres;Password=pa$$w0rd;Database=postgres")) //{ // conn.Open(); // using (var cmd = new NpgsqlCommand()) // { // cmd.Connection = conn; // // Insert some data // //cmd.CommandText = "INSERT INTO data (some_field) VALUES ('Hello world')"; // //cmd.ExecuteNonQuery(); // // Retrieve all rows // cmd.CommandText ="SELECT Id, Name FROM public.Teste"; // using (var reader = cmd.ExecuteReader()) // { // while (reader.Read()) // { // Console.WriteLine(reader.GetString(0)); // } // } // } //} //return null; }
public void Setup() { var dbfactory = new DatabaseFactory(); dbfactory .Config() .UsingDatabase(() => new Database("", DatabaseType.SqlServer2012, SqlClientFactory.Instance)) .WithFluentConfig(FluentMappingConfiguration.Configure(new MyMappings())); _database = dbfactory.GetDatabase(); }