-
Marcos Bolonha
- SnapDevelop
- Tuesday, 13 April 2021 12:02 AM UTC
Hi,
I'm working on my first .Net DataStore Web Api project and it is really different from PBScript. On DB Server we have many databases (same structure) for different customers (tenants) and I would like to send the database name via HTTP header like:
inv_RESTClient.SetRequestHeader("DbName", "MyDbName")
How can I handle this on Web Api project?
Today I have a appsettings.json:
{
"ConnectionStrings": {
"Test": "Data Source=SRVDB,1433;Initial Catalog=MyDb;Integrated Security=False;User ID=sa;Password=adm;Pooling=True;Min Pool Size=0;Max Pool Size=100;MultipleActiveResultSets=False;Encrypt=False;TrustServerCertificate=False;ApplicationIntent=ReadWrite"
}
}
and the TestDataContext.cs:
using SnapObjects.Data;
using SnapObjects.Data.SqlServer;
namespace Test
{
public class TestDataContext : SqlServerDataContext
{
public TestDataContext(string connectionString)
: this(new SqlServerDataContextOptions<TestDataContext>(connectionString))
{
}
public TestDataContext(IDataContextOptions<TestDataContext> options)
: base(options)
{
}
public TestDataContext(IDataContextOptions options)
: base(options)
{
}
}
}
and startup.cs:
...
namespace Test
{
public class Startup
{
public Startup(IConfiguration configuration)
{
Configuration = configuration;
}
public IConfiguration Configuration { get; }
public void ConfigureServices(IServiceCollection services)
{
services.AddControllers(m =>
{
m.UseCoreIntegrated();
m.UsePowerBuilderIntegrated(); //add UsePowerBuilderIntegrated
});
// Original AddDataContext
//services.AddDataContext<TestDataContext>(m => m.UseSqlServer(this.Configuration, "Test"));
// Actual AddDataContext
string DbName = "MyDbName"; // ==>> I would like to get de HTTP Request Header "DbName" at this point
SqlConnectionStringBuilder builder = new SqlConnectionStringBuilder(Configuration.GetConnectionString("Test"));
builder.InitialCatalog = DbName;
services.AddDataContext<TestDataContext>(m => m.UseSqlServer(builder.ConnectionString));
...
Thanks.
Marcos
PB 2019 R3 Build 2670
Find Questions by Tag
Helpful?
If a reply or comment is helpful for you, please don’t hesitate to click the Helpful button. This action is further confirmation of their invaluable contribution to the Appeon Community.