/// <summary> /// Connects to the database. /// </summary> /// <param name="sqlitePlatform">The sqlite platform.</param> /// <param name="connectionString">The connection string.</param> public async Task ConnectAsync(ISQLitePlatform sqlitePlatform, SQLiteConnectionString connectionString) { if(IsConnected) { throw new InvalidOperationException("Database connection already connected!"); } await LockAsync().ConfigureAwait(false); try { _connectionString = connectionString; Logger.Debug($"Opening connection to database {_connectionString.ConnectionString}..."); Connection = new SQLiteConnectionWithLock(sqlitePlatform, connectionString); AsyncConnection = new SQLiteAsyncConnection(() => Connection); } finally { Release(); } }
private static SQLiteAsyncConnection CreateDatabaseAsync() { // Create a new connection try { var platform = new SQLite.Net.Platform.WinRT.SQLitePlatformWinRT(); var dbPath = Path.Combine(ApplicationData.Current.LocalFolder.Path,"Storage.SQLite"); var connectionString = new SQLiteConnectionString(dbPath, true); var dbLockedCon = new SQLiteConnectionWithLock(platform ,connectionString); var db = new SQLiteAsyncConnection(() => dbLockedCon); //Create the tables that do not exist Type[] tables = { typeof(Folders) , typeof(Accounts) , typeof(Emails) , typeof(EmailFrom) , typeof(EmailSender) , typeof(EmailReplyTo) , typeof(Settings) }; var d = db.CreateTablesAsync(tables).Result; return db; } catch(Exception e) { var mess = e.Message; throw; } }
public SQLiteAsyncConnection GetConnection() { string documentsPath = Environment.GetFolderPath(Environment.SpecialFolder.Personal); string path = Path.Combine(documentsPath, AppResources.DatabaseName); var platfrom = new SQLitePlatformAndroid(); var syncConnection = new SQLiteConnectionWithLock(platfrom, new SQLiteConnectionString(path, false)); return new SQLiteAsyncConnection(() => syncConnection); }
public SQLiteAsyncConnection ResolveConnection() { var path = Path.Combine ( Environment.GetFolderPath (Environment.SpecialFolder.Personal), "tasks.db"); var connection = new SQLiteConnectionWithLock (new SQLite.Net.Platform.XamarinIOS.SQLitePlatformIOS(), new SQLiteConnectionString(path, false)); return new SQLiteAsyncConnection (() => connection); }
public SQLiteConnection GetConnection(string path) { var fullPath = GetFullDatabasePath (path); var platform = new SQLitePlatformIOS (); var connectionWithLock = new SQLiteConnectionWithLock (platform, new SQLiteConnectionString (fullPath, true)); return connectionWithLock; }
public SqliteContext(ISQLitePlatform platform,DatabaseInitializator init) { _platform = platform; _init = init; _dbPath = init.Path; var connection = new SQLiteConnectionWithLock(_platform, new SQLiteConnectionString(_dbPath, storeDateTimeAsTicks: true)); _connectionFactory = new Func<SQLiteConnectionWithLock>(() =>connection); CreateTables(); }
public virtual SQLiteConnection GetConnection(string path) { var platform = new SQLitePlatformAndroid (); SQLiteConnection connectionWithLock; string fullPath = GetFullDatabasePath (path); connectionWithLock = new SQLiteConnectionWithLock (platform, new SQLiteConnectionString (fullPath, true)); return connectionWithLock; }
private void InitialiseDatabase() { var databasePath = GetDatabaseFilePath(); _sqLiteConnectionWithLock = new SQLiteConnectionWithLock(new SQLitePlatformIOS(), new SQLiteConnectionString(databasePath, storeDateTimeAsTicks: false)); SqLiteAsyncConnection = new SQLiteAsyncConnection(() => _sqLiteConnectionWithLock); CreateTables(); }
public SQLiteConnection GetConnection() { var sqliteFilename = "IncidentsSQLite.db3"; string documentsPath = Environment.GetFolderPath (Environment.SpecialFolder.Personal); // Documents folder var path = Path.Combine (documentsPath, sqliteFilename); var platform = new SQLitePlatformAndroid (); var sqLiteConnectionString = new SQLiteConnectionString(path, false); var conn = new SQLiteConnectionWithLock (platform, sqLiteConnectionString); return conn; }
// public SQLiteAsyncConnection GetConnection() // { //var documentsPath = Environment.GetFolderPath(Environment.SpecialFolder.MyDocuments); //var path = Path.Combine(documentsPath, "MySQLite.db3"); //Console.WriteLine(path); //return new SQLiteAsyncConnection(path); //} public SQLite.Net.Async.SQLiteAsyncConnection GetConnection() { var documentsPath = Environment.GetFolderPath(Environment.SpecialFolder.MyDocuments); var path = Path.Combine(documentsPath, "MySQLite.db3"); var connectionString = new SQLite.Net.SQLiteConnectionString(path, false); var connectionWithLock = new SQLite.Net.SQLiteConnectionWithLock(new SQLite.Net.Platform.XamarinIOS.SQLitePlatformIOS(), connectionString); var connection = new SQLite.Net.Async.SQLiteAsyncConnection(() => connectionWithLock); return(connection); }
public SQLiteAsyncConnection GetAsyncConnection() { var sqliteFilename = "IncidentsSQLite.db3"; string documentsPath = Environment.GetFolderPath (Environment.SpecialFolder.Personal); // Documents folder string libraryPath = Path.Combine (documentsPath, "..", "Library"); // Library folder var path = Path.Combine (libraryPath, sqliteFilename); var platform = new SQLitePlatformIOS (); var sqLiteConnectionString = new SQLiteConnectionString(path, false); var conn = new SQLiteConnectionWithLock (platform, sqLiteConnectionString); var connAsync = new SQLiteAsyncConnection (() => conn); return connAsync; }
public App () { var sqliteFilename = "phoenix_imperator_" + Version.Replace(".","_") + ".db3"; string documentsPath = GetDocumentPath (); #if __ANDROID__ var path = Path.Combine(documentsPath, sqliteFilename); #else string libraryPath = Path.Combine (documentsPath, "..", "Library"); // Library folder var path = Path.Combine(libraryPath, sqliteFilename); #endif _dbConnection = new SQLiteConnectionWithLock (DatabasePlatform, new SQLiteConnectionString (path, storeDateTimeAsTicks: true)); Console.WriteLine("SQL Database: " + path); Phoenix.Application.Initialize (this, this, this, this); MainPage = new RootPage (); }
public SQLite.Net.Async.SQLiteAsyncConnection ResolveConnection() { try { var path = Path.Combine ( Environment.GetFolderPath (Environment.SpecialFolder.Personal), "tasks.db"); var connection = new SQLiteConnectionWithLock (new SQLite.Net.Platform.XamarinAndroid.SQLitePlatformAndroid(), new SQLiteConnectionString(path, false) ); return new SQLiteAsyncConnection (() => connection); } catch (Exception ex) { return null; } }
public SQLiteAsyncConnection GetAsyncConnection() { var dbPath = GetDatabaseFilePath(); var platForm = new SQLitePlatformIOS(); var connectionFactory = new Func <SQLiteConnectionWithLock>( () => _sqLiteConnectionWithLock ?? (_sqLiteConnectionWithLock = new SQLiteConnectionWithLock( platForm, new SQLiteConnectionString(dbPath, storeDateTimeAsTicks: true)))); var asyncConnection = new SQLiteAsyncConnection(connectionFactory); return(asyncConnection); }
/// <summary> /// Platform (Android) connection. /// </summary> protected override SQLiteAsyncConnection PlatformConnection() { var dbPath = Path.Combine( Environment.GetFolderPath(Environment.SpecialFolder.Personal), Path.Combine(ApplicationName, "SimpleObjectCache")); Directory.CreateDirectory(dbPath); var lockedConnection = new SQLiteConnectionWithLock( new SQLite.Net.Platform.XamarinAndroid.SQLitePlatformAndroid(), new SQLiteConnectionString( Path.Combine(dbPath, "cache.db3"), true)); return new SQLiteAsyncConnection(() => lockedConnection); }
public SQLiteAsyncConnection GetConnection() { const string sqliteFilename = "Conferences.db3"; var path = Path.Combine(ApplicationData.Current.LocalFolder.Path, sqliteFilename); var platform = new SQLitePlatformWinRT(); var connectionWithLock = new SQLiteConnectionWithLock( platform, new SQLiteConnectionString(path, true)); var connection = new SQLiteAsyncConnection(() => connectionWithLock); return connection; }
public SQLiteAsyncConnection GetConnection() { const string sqliteFilename = "Conferences.db3"; var documentsPath = Environment.GetFolderPath(Environment.SpecialFolder.Personal); var path = Path.Combine(documentsPath, sqliteFilename); var platform = new SQLitePlatformAndroid(); var connectionWithLock = new SQLiteConnectionWithLock( platform, new SQLiteConnectionString(path, true)); var connection = new SQLiteAsyncConnection(() => connectionWithLock); return connection; }
public SQLiteAsyncConnection GetAsyncConnection() { const string sqliteFilename = "XamarinTemplate.db3"; var documentsPath = Environment.GetFolderPath(Environment.SpecialFolder.Personal); var libraryPath = Path.Combine(documentsPath, "..", "Library"); var path = Path.Combine(libraryPath, sqliteFilename); var platform = new SQLitePlatformIOS(); var connectionWithLock = new SQLiteConnectionWithLock( platform, new SQLiteConnectionString(path, true)); var connection = new SQLiteAsyncConnection(() => connectionWithLock); return connection; }
public Data() { // will be created if non-existent this.dbFilePath = Path.Combine( ApplicationData.Current.LocalFolder.Path, "db.sqlite"); this.dbContext = new SQLiteConnectionWithLock( new SQLitePlatformWinRT(), new SQLiteConnectionString( dbFilePath, storeDateTimeAsTicks: false) ); this.init(); this.localFolder = ApplicationData.Current.LocalFolder; }
public static SQLiteAsyncConnection CreateAsyncConnection() { var connectionString = new SQLiteConnectionString(DatabaseFilePath, false); var connectionWithLock = new SQLiteConnectionWithLock(new SQLitePlatformIOS(), connectionString); return new SQLiteAsyncConnection(() => connectionWithLock); }
public void OnApplicationSuspended() { Connection.Dispose(); Connection = null; }
public Entry(ISQLitePlatform sqlitePlatform, SQLiteConnectionString connectionString) { ConnectionString = connectionString; Connection = new SQLiteConnectionWithLock(sqlitePlatform, connectionString); }
public SQLiteService(ISQLitePlatform platform, SQLiteConnectionString connectionString) { connection = new SQLiteConnectionWithLock(platform, connectionString); context = new SQLiteAsyncConnection(() => connection); isDisposed = false; }
public void Drop() { connectionLock = new SQLiteConnectionWithLock(platform, new SQLiteConnectionString(DbPath, false)); var connection = new SQLiteAsyncConnection(() => connectionLock); connection.DropTableAsync<BackgroundTrackItem>(); }
public Task Remove(BackgroundTrackItem track) { connectionLock = new SQLiteConnectionWithLock(platform, new SQLiteConnectionString(DbPath, false)); var connection = new SQLiteAsyncConnection(() => connectionLock); return connection.DeleteAsync(track); }
public static void Main() { Task.Run(() => { SplashScreen splashScreen = new SplashScreen("SplashScreen.png"); splashScreen.Show(true); }); // Logger initialization string pathtolog = null; try { pathtolog = Path.Combine(FileService.GetPathToApplicationDataFolder(), "log.db"); SQLiteConnectionString connstr = new SQLiteConnectionString(pathtolog,false); SQLiteConnectionWithLock SQLiteLogConnection = new SQLiteConnectionWithLock(new SQLitePlatformWin32(), connstr); LoggerSettings LoggerSettings = new LoggerSettings(); LoggerSettings.DeleteMessagesOnStart = true; Logger.LoggerSettings = LoggerSettings; //SQLiteLoggerAdapter.Initialization(LoggerSettings,SQLiteLogConnection); App.StaticLogger = new Logger(new SQLiteLoggerAdapter(LoggerSettings,new SQLiteAsyncConnection(()=>SQLiteLogConnection))); } catch(Exception ex) { MessageBox.Show("Cannot create a log"+Environment.NewLine+"path: "+pathtolog+Environment.NewLine+ex.Message); return; } App.StaticLogger.Write<Program>(LogMsgType.Trace,"This is developer copy = "+FileService.IsDevelopmentCopy); App.StaticLogger.Write<Program>(LogMsgType.Trace,"App folder : "+FileService.GetPathToApplicationFolder()); App.StaticLogger.Write<Program>(LogMsgType.Trace,"App data folder : "+FileService.GetPathToApplicationDataFolder()); //if (!FileService.IsDevelopmentCopy) //{ string path = FileService.GetPathToApplicationDataFolder(); AppDomain.CurrentDomain.SetData("DataDirectory",path); //} if (!Debugger.IsAttached) { //App.SplashScreen = new SplashScreen("Images/TxFlag_256.png"); //App.SplashScreen.Show(false, true); } // Make sure the settings are properly saved in the end //AppDomain.CurrentDomain.ProcessExit += CurrentDomain_ProcessExit; App.StaticLogger.Write<Program>(LogMsgType.Trace,"Loading a localization file"); Tx.UseFileSystemWatcher = false; Tx.LoadFromXmlFile(Path.Combine(FileService.GetPathToApplicationFolder(), "Dictionary.txd")); App.StaticLogger.Write<Program>(LogMsgType.Trace,"Set culture"); string appCulture = ""; if (!string.IsNullOrWhiteSpace(appCulture)) { Tx.SetCulture(appCulture); } //EFDbContext.DataBase.Migrate(); App.AppWnd_ViewModel = new AppWnd_ViewModel(); App.NavigationService = new NavigationService(App.AppWnd_ViewModel); try { App app = new App(); app.InitializeComponent(); app.Run(); } catch(Exception ex) { if (ex.GetType() != typeof(ObjectNotInitializedYetException)) { App.StaticLogger.WriteExeption<Program>(ex, "General exception"); MessageBox.Show( "General exception " + Environment.NewLine + ex.Message + Environment.NewLine + "Exception type :" + ex.GetType() + Environment.NewLine + "Stack trace :" + Environment.NewLine + ex.StackTrace ); //SQLiteLoggerAdapter.Close(); throw; } } }
public Task AddBunchTracks(dynamic tracks) { connectionLock = new SQLiteConnectionWithLock(platform, new SQLiteConnectionString(DbPath, false)); var connection = new SQLiteAsyncConnection(() => connectionLock); return connection.InsertAllAsync(tracks); }