public override object[] GetContextConstructorArguments(IConnectionInfo cxInfo)
{
var connString = connectionStringService.GetConnectionString(cxInfo);
var connection = new CrmServiceClient(connString);
return(new object[] { connection });
}
public ReportsConfig Create(string odsInstanceName, ApiMode apiMode)
{
return(new ReportsConfig
{
ConnectionString = _connectionStringService.GetConnectionString(odsInstanceName, apiMode),
ScriptFolder = DatabaseProviderHelper.PgSqlProvider ? "Reports.PgSql" : "Reports.Sql"
});
}
public PocoContext(IConnectionStringService connectionStringService)
{
_connectionStringService = connectionStringService;
Database.SetInitializer <PocoContext>(null);
//Sets the connection string to the database, to which the objects are generated
this.Database.Connection.ConnectionString = _connectionStringService.GetConnectionString();
}
public PocoContext(IConnectionStringService connectionStringService)
{
_connectionStringService = connectionStringService;
Database.SetInitializer<PocoContext>(null);
//Sets the connection string to the database, to which the objects are generated
this.Database.Connection.ConnectionString = _connectionStringService.GetConnectionString();
}
public ReportsConfig Create(string odsInstanceName, ApiMode apiMode)
{
var isPostgreSql = ApiConfigurationConstants.PostgreSQL.Equals(_appSettings.Value.DatabaseEngine, StringComparison.InvariantCultureIgnoreCase);
return(new ReportsConfig
{
ConnectionString = _connectionStringService.GetConnectionString(odsInstanceName, apiMode),
ScriptFolder = isPostgreSql ? "Reports.PgSql" : "Reports.Sql"
});
}
public IDbConnection CreateNewConnection(string odsInstanceName, ApiMode apiMode)
{
var connectionString = _connectionStringService.GetConnectionString(odsInstanceName, apiMode);
if (DatabaseProviderHelper.PgSqlProvider)
{
return(new NpgsqlConnection(connectionString));
}
return(new SqlConnection(connectionString));
}
public async Task <List <T> > ExecuteStoredProcedure <T>(string query, params object[] parameters) where T : class
{
var optionsBuilder = new DbContextOptionsBuilder <CMSClientContext>();
var connectionString = await _connectionStringService.GetConnectionString();
optionsBuilder.UseSqlServer(connectionString);
await using var context = new CMSClientContext(optionsBuilder.Options);
return(await context.Set <T>().FromSqlRaw(query, parameters).ToListAsync());
}
public IDbConnection CreateNewConnection(string odsInstanceName, ApiMode apiMode)
{
var connectionString = _connectionStringService.GetConnectionString(odsInstanceName, apiMode);
var isPostgreSql = ApiConfigurationConstants.PostgreSQL.Equals(_appSettings.Value.DatabaseEngine, StringComparison.InvariantCultureIgnoreCase);
if (isPostgreSql)
{
return(new NpgsqlConnection(connectionString));
}
return(new SqlConnection(connectionString));
}
static void Main(string[] args)
{
var basicHttpBinding = new BasicHttpBinding();
var endpont = new EndpointAddress("http://localhost:8080/RoutingService/RoutingService.StoredConnectionStringsService.svc");
var connectionStringService = new ChannelFactory <IConnectionStringService>(basicHttpBinding, endpont);
IConnectionStringService client = connectionStringService.CreateChannel();
ConnectionString connectionString = client.GetConnectionString("RoutingService", "abcd1234", "DefaultConnectionString");
IClientChannel chanel = (IClientChannel)client;
chanel.Close();
chanel.Dispose();
Console.WriteLine(connectionString);
Console.ReadKey();
}
private async Task <object> GenerateDllClicked(object arg)
{
if (String.IsNullOrWhiteSpace(ConnectionInfo.DatabaseInfo.CustomCxString))
{
await Task.Run(async() => { throw new Exception("Missing connection string."); });
}
if (String.IsNullOrWhiteSpace(ConnectionInfo.DatabaseInfo.CustomCxString))
{
await Task.Run(async() => { throw new Exception("Missing connection server."); });
}
string workingDirectory = contextGenerator.GetWorkingFolder(ConnectionInfo.DatabaseInfo);
if (!Directory.Exists(workingDirectory))
{
Directory.CreateDirectory(workingDirectory);
}
string fileName = Path.Combine(workingDirectory, "ContextCode.cs");
var connectionString = connectionStringService.GetConnectionString(ConnectionInfo);
bool codeGenerated = await contextGenerator.GenerateCode(connectionString, fileName);
if (codeGenerated)
{
var hostname = new Uri(ConnectionInfo.DatabaseInfo.Server).Host;
var dllPath = Path.Combine(workingDirectory, hostname + ".dll");
var logFile = Path.Combine(workingDirectory, compilationLogFilename);
var compilationErrors = await compilerService.CompileCode(fileName, dllPath, logFile);
if (compilationErrors.Length == 0)
{
SetDllPath(dllPath);
}
else
{
await Task.Run(async() => { throw new Exception("Error while compiling code:" + Environment.NewLine + String.Join(Environment.NewLine, compilationErrors)); });
}
}
else
{
await Task.Run(async() => { throw new Exception("Error while generating code."); });
}
return(null);
}
