// This method gets called by the runtime. Use this method to configure the HTTP request pipeline.
public void Configure(IApplicationBuilder app, IWebHostEnvironment env)
{
//docker run -e "ACCEPT_EULA=Y" -e "MSSQL_SA_PASSWORD=P@ssw0rd!" -p 1400:1433 -d mcr.microsoft.com/mssql/server:2017-latest
var traceService = new ConsoleTraceService {
IsDebugEnabled = true
};
app.UseYuniql(traceService, new YuniqlConfiguration
{
WorkspacePath = Path.Combine(Environment.CurrentDirectory, "_db"),
ConnectionString = "Server=localhost,1400;Database=yuniqldb;User Id=SA;Password=P@ssw0rd!",
AutoCreateDatabase = true,
Tokens = new List <KeyValuePair <string, string> > {
new KeyValuePair <string, string>("VwColumnPrefix1", "Vw1"),
new KeyValuePair <string, string>("VwColumnPrefix2", "Vw2"),
new KeyValuePair <string, string>("VwColumnPrefix3", "Vw3"),
new KeyValuePair <string, string>("VwColumnPrefix4", "Vw4")
}
});
app.UseRouting();
app.UseEndpoints(endpoints =>
{
endpoints.MapGet("/", async context =>
{
await context.Response.WriteAsync("Hello World!");
});
});
}
// This method gets called by the runtime. Use this method to configure the HTTP request pipeline.
public void Configure(IApplicationBuilder app, IWebHostEnvironment env)
{
//1. deploy new sql server on docker
//$ docker run -dit --name yuniql-sqlserver -e "ACCEPT_EULA=Y" -e "MSSQL_SA_PASSWORD=P@ssw0rd!" -p 1400:1433 -d mcr.microsoft.com/mssql/server:2017-latest
//2. create custom trace message sinks, this can be your own logger framework
var traceService = new ConsoleTraceService {
IsDebugEnabled = true
};
//3. run migrations
app.UseYuniql(traceService, new Yuniql.AspNetCore.Configuration
{
Platform = "sqlserver",
Workspace = Path.Combine(Environment.CurrentDirectory, "_db"),
ConnectionString = "Server=localhost,1400;Database=helloyuniql;User Id=SA;Password=P@ssw0rd!",
IsAutoCreateDatabase = true, IsDebug = true
});
app.UseRouting();
app.UseEndpoints(endpoints =>
{
endpoints.MapGet("/", async context =>
{
await context.Response.WriteAsync("Hello World!");
});
});
}
// This method gets called by the runtime. Use this method to configure the HTTP request pipeline.
public void Configure(IApplicationBuilder app, IWebHostEnvironment env)
{
//docker run -e POSTGRES_USER=sa -e POSTGRES_PASSWORD=P@ssw0rd! -e POSTGRES_DB=yuniqldb -p 5432:5432 postgres
var traceService = new ConsoleTraceService {
IsDebugEnabled = true
};
var configuration =
app.UseYuniql(
new PostgreSqlDataService(traceService),
new PostgreSqlBulkImportService(traceService),
traceService, new YuniqlConfiguration
{
WorkspacePath = Path.Combine(Environment.CurrentDirectory, "_db"),
ConnectionString = "Host=localhost;Port=5432;Username=sa;Password=P@ssw0rd!;Database=yuniqldb",
AutoCreateDatabase = true
});
app.UseRouting();
app.UseEndpoints(endpoints =>
{
endpoints.MapGet("/", async context =>
{
await context.Response.WriteAsync("Hello World!");
});
});
}
// This method gets called by the runtime. Use this method to configure the HTTP request pipeline.
public void Configure(IApplicationBuilder app, IWebHostEnvironment env)
{
//1. deploy new postgresql on docker
//$ docker run -dit -e POSTGRES_USER=sa -e POSTGRES_PASSWORD=P@ssw0rd! -e POSTGRES_DB=yuniqldb -p 5432:5432 postgres
//2. create custom trace message sinks
var traceService = new ConsoleTraceService {
IsDebugEnabled = true
};
//3. run migrations
app.UseYuniql(
//use Yuniql.PostgreSql providers here
new PostgreSqlDataService(traceService),
new PostgreSqlBulkImportService(traceService),
traceService, new Configuration
{
WorkspacePath = Path.Combine(Environment.CurrentDirectory, "_db"),
ConnectionString = "Host=localhost;Port=5432;Username=sa;Password=P@ssw0rd!;Database=yuniqldb",
AutoCreateDatabase = true, DebugTraceMode = true
});;
app.UseRouting();
app.UseEndpoints(endpoints =>
{
endpoints.MapGet("/", async context =>
{
await context.Response.WriteAsync("Hello World!");
});
});
}