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