public DbConnection CreateConnection(string nameOrConnectionString)
{
if (filePath == null)
{
filePath = DataDirectoryHelper.GetFile("expenses.sqlite3", DataDirectoryHelper.DataFolderName);
File.SetAttributes(filePath, File.GetAttributes(filePath) & ~FileAttributes.ReadOnly);
}
return(new SQLiteConnection(new SQLiteConnectionStringBuilder {
DataSource = filePath
}.ConnectionString));
}
static DbConnection CreateConnection()
{
if (filePath == null)
{
filePath = DataDirectoryHelper.GetFile("doctors.db", DataDirectoryHelper.DataFolderName);
}
File.SetAttributes(filePath, File.GetAttributes(filePath) & ~FileAttributes.ReadOnly);
var connection = DbProviderFactories.GetFactory("System.Data.SQLite.EF6").CreateConnection();
connection.ConnectionString = new SQLiteConnectionStringBuilder {
DataSource = filePath
}.ConnectionString;
return(connection);
}
static void SetFilePath()
{
if (filePath == null)
{
filePath = DataDirectoryHelper.GetFile("devav.sqlite3", DataDirectoryHelper.DataFolderName);
}
try {
var attributes = File.GetAttributes(filePath);
if (attributes.HasFlag(FileAttributes.ReadOnly))
{
File.SetAttributes(filePath, attributes & ~FileAttributes.ReadOnly);
}
} catch { }
}
static DbConnection CreateConnection()
{
if (filePath == null)
{
filePath = DataDirectoryHelper.GetFile("cars.db", DataDirectoryHelper.DataFolderName);
}
try {
var attributes = File.GetAttributes(filePath);
if (attributes.HasFlag(FileAttributes.ReadOnly))
{
File.SetAttributes(filePath, attributes & ~FileAttributes.ReadOnly);
}
} catch { }
var connection = DbProviderFactories.GetFactory("System.Data.SQLite.EF6").CreateConnection();
connection.ConnectionString = new SQLiteConnectionStringBuilder {
DataSource = filePath
}.ConnectionString;
return(connection);
}
public static string GetDataFilePath(string relativePath)
{
return(DataDirectoryHelper.GetFile(relativePath, DataDirectoryHelper.DataFolderName));
}
