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); }