public void FluentMappingForPrivates()
{
var map = FluentMappingConfiguration.Configure(new FluentMappingOverridesForPrivates());
var pd = map.Config(new MapperCollection()).Resolver(typeof(NewMapperTests.Result36), new PocoDataFactory(new MapperCollection())).Build();
Assert.AreEqual(true, pd.Columns.ContainsKey("Data"));
}
static NPocoDatabase()
{
factory = DatabaseFactory.Config(x => {
x.UsingDatabase(() => new NPocoDatabase("connectionStringName"));
x.WithFluentConfig(FluentMappingConfiguration.Configure(new NPocoDatabaseMappings()));
});
}
private IDatabase CreateDatabaseInstance(IHostingEnvironment env)
{
Database database;
if (env.IsDevelopment())
{
var s = new SqliteIntegration();
s.EnsureSharedConnectionConfigured();
database = s.CreateDatabase();
s.RecreateSchema();
}
else
{
database = new Database("Server=localhost;Database=npoco;Trusted_Connection=True;",
DatabaseType.SqlServer2012,
SqlClientFactory.Instance);
}
var dbFactory = DatabaseFactory.Config(x =>
{
var fluentConfig = FluentMappingConfiguration.Configure(new NPocoLabMappings());
x.UsingDatabase(() => database);
x.WithFluentConfig(fluentConfig);
});
return(dbFactory.GetDatabase());
}
// This method gets called by the runtime. Use this method to add services to the container.
public void ConfigureServices(IServiceCollection services)
{
var connection = Configuration.GetConnectionString("DefaultConnection");
var dbFactory = DatabaseFactory.Config(x =>
{
x.UsingDatabase(() => new Database(connection, DatabaseType.SqlServer2012, System.Data.SqlClient.SqlClientFactory.Instance));
x.WithFluentConfig(FluentMappingConfiguration.Configure(new NpocoMappings()));
});
services.AddSingleton(dbFactory);
services.AddControllers();
services.AddScoped <IUserService, UserService>();
services.AddScoped <IVehicleService, VehicleService>();
services.AddCors(options =>
{
options.AddPolicy("AllowAllOrigins",
builder =>
{
builder.AllowAnyOrigin();
builder.AllowAnyHeader();
builder.AllowAnyMethod();
});
});
// services.AddSwaggerGen(c =>
// {
// c.SwaggerDoc("v1", new Info { Title = "API", Version = "v1" });
// });
}
public void Setup()
{
var config = FluentMappingConfiguration.Configure(new ServerDomainDBMapping());
DbFactory = DatabaseFactory.Config(x =>
{
x.UsingDatabase(() => new Database(this.connectionString, DatabaseType.SQLite));
x.WithFluentConfig(config);
});
}
/// <summary>
///
/// </summary>
public static void Setup()
{
var fluentConfig = FluentMappingConfiguration.Configure(new SqliteMappings());
DbFactory = DatabaseFactory.Config(x =>
{
x.UsingDatabase(() => new NPoco.Database("conndb", NPoco.DatabaseType.SQLite));
x.WithFluentConfig(fluentConfig);
});
}
/// <summary>
///
/// </summary>
public static void Setup(string config)
{
var fluentConfig = FluentMappingConfiguration.Configure(new ReviewsServiceMappings());
DbFactory = DatabaseFactory.Config(x =>
{
x.UsingDatabase(() => new NPoco.Database(config, DatabaseType.SqlServer2012, SqlClientFactory.Instance));
x.WithFluentConfig(fluentConfig);
});
}
public static void Setup(IConfiguration configuration)
{
var fluentConfig = FluentMappingConfiguration.Configure(new LunchMapping(), new AttendeeMapping());
DbFactory = DatabaseFactory.Config(x =>
{
x.UsingDatabase(() => new Database(configuration.GetConnectionString("LocsDatabase"), DatabaseType.SqlServer2012, SqlClientFactory.Instance));
x.WithFluentConfig(fluentConfig);
});
}
public static void Setup()
{
var config = FluentMappingConfiguration.Configure(new CustomMappings());
DatabaseFactory = DatabaseFactory.Config(x =>
{
x.UsingDatabase(() => new MemeDatabase("MemeLordDb"));
x.WithFluentConfig(config);
});
}
public void Setup()
{
var dbfactory = new DatabaseFactory();
dbfactory
.Config()
.UsingDatabase(() => new Database(""))
.WithFluentConfig(FluentMappingConfiguration.Configure(new MyMappings()));
_database = dbfactory.GetDatabase();
}
/// <summary>
///
/// </summary>
public static void Setup(string config)
{
//NpgsqlConnection connection = new NpgsqlConnection(config);
var fluentConfig = FluentMappingConfiguration.Configure(new OTPSolutionMappings());
DbFactory = DatabaseFactory.Config(x =>
{
x.UsingDatabase(() => new NPoco.Database(config, DatabaseType.SqlServer2012, SqlClientFactory.Instance));
x.WithFluentConfig(fluentConfig);
});
}
public static void Setup(Mappings MappingClass)
{
var fluentConfig = FluentMappingConfiguration.Configure(MappingClass);
DbFactory = DatabaseFactory.Config(x =>
{
x.UsingDatabase(() => new Database("CommandsDb"));
x.WithFluentConfig(fluentConfig);
//x.WithMapper(new Mapper());
});
}
public static void Setup()
{
FluentConfig fluentConfig = FluentMappingConfiguration.Configure(new EmployeeMapping());
DbFactory = DatabaseFactory.Config(x =>
{
x.UsingDatabase(() => new SqlServerDatabase(AppSettings.StringConnection));
x.WithFluentConfig(fluentConfig);
x.WithMapper(new Mapper());
});
}
public void Setup()
{
var dbfactory = new DatabaseFactory();
dbfactory
.Config()
.UsingDatabase(() => new Database("", new SqlServer2012DatabaseType(), SqlClientFactory.Instance))
.WithFluentConfig(FluentMappingConfiguration.Configure(new MyMappings()));
_database = dbfactory.GetDatabase();
}
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 Initialize()
{
var fluentConfig = FluentMappingConfiguration.Configure
(
// new CostumeMapping()
);
DbFactory = DatabaseFactory.Config(x =>
{
x.WithFluentConfig(fluentConfig);
x.WithInterceptor(new NPocoDbInterceptors());
});
}
public Database CreateDatabase()
{
var fluentConfig = FluentMappingConfiguration.Configure(new NPocoLabMappings());
var dbFactory = DatabaseFactory.Config(x =>
{
x.UsingDatabase(() => new Database(Connection, DatabaseType.SQLite));
x.WithFluentConfig(fluentConfig);
});
return(dbFactory.GetDatabase());
}
public static void Initialize()
{
var fluentConfig = FluentMappingConfiguration.Configure
(
new CustomerMapping()
);
DbFactory = DatabaseFactory.Config(x =>
{
x.WithFluentConfig(fluentConfig);
x.WithInterceptor(new DataServiceInterceptors());
});
}
public static void Setup()
{
var fluentConfig = FluentMappingConfiguration.Configure(new OurMappings());
//or individual mappings
//var fluentConfig = FluentMappingConfiguration.Configure(new UserMapping(), ....);
DbFactory = DatabaseFactory.Config(x =>
{
// Load the connection string here or just use a constant in code...
x.UsingDatabase(() => new Database("connString");
x.WithFluentConfig(fluentConfig);
x.WithMapper(new Mapper());
});
}
/// <summary>
/// Initializes the configuration and sets the <see cref="Factory"/> property.
/// </summary>
/// <remarks>Adapted from https://github.com/schotime/NPoco/wiki/Fluent-Mappings-including-Conventional
/// </remarks>
public static void Setup(IDatabaseConfigurationSettings databaseConfigurationSettings)
{
var fluentConfig = FluentMappingConfiguration.Configure(new IMap[]
{
new LocationInformationMapping(),
new PropertyEnquiryMapping(),
new PropertyInformationMapping(),
new PropertyPhotoMapping()
});
Factory = DatabaseFactory.Config(x =>
{
x.UsingDatabase(() => new Database(databaseConfigurationSettings.ConnectionStringName));
x.WithFluentConfig(fluentConfig);
});
}
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();
}
}
public void DifferentFactoriesWithDifferentMappingsGetDifferentPocoDataForSamePocoWithoutFactory()
{
// Assume these factories connect to different data sources
var db1 = new Database(new SqlConnection())
{
PocoDataFactory = new PocoDataFactory(new MapperCollection())
};
var factory2 = DatabaseFactory.Config(x =>
{
x.UsingDatabase(() => new Database(new SqlConnection()));
x.WithFluentConfig(FluentMappingConfiguration.Configure(new AnotherMapping()));
});
var pocoData1 = db1.PocoDataFactory.ForType(typeof(WanderingPoco));
var pocoData2 = factory2.GetDatabase().PocoDataFactory.ForType(typeof(WanderingPoco));
Assert.AreEqual("Table1", pocoData1.TableInfo.TableName);
Assert.AreEqual("Table2", pocoData2.TableInfo.TableName);
}