public SqlAccessService() { _connectionString = ConfigurationManagerKeys.Configuration().ConnectionString; Task.Run(async() => { _objectToDbMapper = await ObjectToDbMapperFactory <TEntity> .Create(); }).Wait(); _dataTableName = _objectToDbMapper.TableName; }
public static void CreateLocalDb(string databaseName, List <string> scriptsName, bool deleteIfExists = false) { _connectionString = ConfigurationManagerKeys.Configuration().ConnectionString; string codeBase = Assembly.GetExecutingAssembly().CodeBase; UriBuilder uri = new UriBuilder(codeBase); string path = Uri.UnescapeDataString(uri.Path); // return Path.GetDirectoryName(path); string outputFolder = Path.Combine(Path.GetDirectoryName(path), DbDirectory); string mdfFilename = databaseName + ".mdf"; string databaseFileName = Path.Combine(outputFolder, mdfFilename); // Create Data Directory If It Doesn't Already Exist. if (!Directory.Exists(outputFolder)) { Directory.CreateDirectory(outputFolder); } if (!CheckDatabaseExists(databaseName)) { ExecuteScript(databaseName, scriptsName); } }
public static void CreateLocalDb(string databaseName, List <string> scriptsName, bool deleteIfExists = false) { if (string.IsNullOrWhiteSpace(ConnectionString)) { ConnectionString = ConfigurationManagerKeys.Configuration().ConnectionString; } string codeBase = Assembly.GetExecutingAssembly().CodeBase; UriBuilder uri = new UriBuilder(codeBase); string path = Uri.UnescapeDataString(uri.Path); // return Path.GetDirectoryName(path); string outputFolder = Path.Combine(Path.GetDirectoryName(path), DbDirectory); string mdfFilename = databaseName + ".mdf"; string databaseFileName = Path.Combine(outputFolder, mdfFilename); // Create Data Directory If It Doesn't Already Exist. if (!Directory.Exists(outputFolder)) { Directory.CreateDirectory(outputFolder); } if (CheckDatabaseExists(databaseName) && deleteIfExists) { DropDatabaseObjects(); } else if (!CheckDatabaseExists(databaseName)) { // If the database does not already exist, create it. CreateDatabase(databaseName, databaseFileName); } if (deleteIfExists) { ExecuteScript(databaseName, scriptsName); } }
public DataBaseManager() { _connectionString = ConfigurationManagerKeys.Configuration().ConnectionString; }