twolfprogrammer

using System;
namespace SQLiteExample {
  public enum Gender {
    Male,
    Female
  }

  public class Person : BaseItem {
    public string FirstName { get; set; }
    public string LastName { get; set; }

twolfprogrammer

using System;
using System.Collections.Generic;
using System.Linq;
using SQLite;
using Xamarin.Forms;

namespace SQLiteExample {
  public class Database {
    static object locker = new object();
    ISQLiteService SQLite {

twolfprogrammer

using SQLite;

namespace SQLiteExample {
  public class BaseItem {
    [PrimaryKey, AutoIncrement]
    public int ID { get; set; }
  }
}

twolfprogrammer

using System;
using System.IO;
using SQLite;
using Xamarin.Forms;

[assembly: Dependency(typeof(SQLiteExample.Droid.SQLiteService))]
namespace SQLiteExample.Droid {
  public class SQLiteService : ISQLiteService {
    string GetPath(string databaseName) {
      if (string.IsNullOrWhiteSpace(databaseName)) {

twolfprogrammer

using System;
using System.IO;
using SQLite;
using Xamarin.Forms;

[assembly: Dependency(typeof(SQLiteExample.iOS.SQLiteService))]
namespace SQLiteExample.iOS {
  public class SQLiteService : ISQLiteService {
    string GetPath(string databaseName) {
      if (string.IsNullOrWhiteSpace(databaseName)) {

twolfprogrammer

using System;
using SQLite;

namespace SQLiteExample {
  public interface ISQLiteService {
    SQLiteConnection GetConnection(string databaseName);
    long GetSize(string databaseName);
  }
}

twolfprogrammer

var otherPage = new OtherPage();
var homePage = App.NavigationPage.Navigation.NavigationStack.First();
App.NavigationPage.Navigation.InsertPageBefore(otherPage, homePage);
App.NavigationPage.PopToRootAsync(false);

twolfprogrammer

  public partial class App : Application {
    public NavigationPage NavigationPage { get; private set; }

    public App() {
      var menuPage = new MenuPage();
      NavigationPage = new NavigationPage(new HomePage());
      var rootPage = new RootPage();
      rootPage.Master = menuPage;
      rootPage.Detail = NavigationPage;
      MainPage = rootPage;

twolfprogrammer

  public partial class RootPage : MasterDetailPage {
    public RootPage() {
      InitializeComponent();
      MasterBehavior = MasterBehavior.Popover;
    }
  }

twolfprogrammer

  public partial class HomePage : ContentPage {
    public HomePage() {
      InitializeComponent();
      // Add your UI code here or in your XAML file
    }
  }