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