LiteDB – Xamarin.Forms

2018-08-18T16:21:26-03:00

Nice article! Should I switch to LiteDB from Sqlite? I write mostly Xamarin.Forms apps.

2018-08-22T20:45:13-03:00

Thanks! In legacy projects I think is not a good idea. But in new projects it’s a good option

	using System;
	using System.IO;
	using DemoLiteDB.Droid;
	using Xamarin.Forms;

	[assembly: Dependency(typeof(Helper))]
	namespace DemoLiteDB.Droid
	{
	public class Helper : IHelper
	{
	public string GetFilePath(string file)
	{
	string path = Environment.GetFolderPath(Environment.SpecialFolder.Personal);
	return Path.Combine(path, file);
	}
	}
	}

	using DemoLiteDB.iOS;
	using System;
	using System.IO;
	using Xamarin.Forms;

	[assembly: Dependency(typeof(Helper))]
	namespace DemoLiteDB.iOS
	{
	public class Helper : IHelper
	{
	public string GetFilePath(string file)
	{
	string document = Environment.GetFolderPath(Environment.SpecialFolder.Personal);
	string library = Path.Combine(document, "..", "Library", "Databases");

	if (!Directory.Exists(library))
	{
	Directory.CreateDirectory(library);
	}

	return Path.Combine(library, file);
	}
	}
	}

	<?xml version="1.0" encoding="utf-8" ?>
	<ContentPage xmlns="http://xamarin.com/schemas/2014/forms"
	xmlns:x="http://schemas.microsoft.com/winfx/2009/xaml"
	xmlns:local="clr-namespace:DemoLiteDB"
	x:Class="DemoLiteDB.MainPage" Title="Demo LiteDB">

	<StackLayout Padding="10">
	<Entry x:Name="EntryName" Placeholder="Name"/>
	<Button Text="Insert" Clicked="Insert"/>
	<Button Text="Get" Clicked="Get" />

	<ListView x:Name="ListCustomers" ItemSelected="List_Selected">
	<ListView.ItemTemplate>
	<DataTemplate>
	<ViewCell>
	<StackLayout Orientation="Horizontal" Padding="10">
	<Label Text="{Binding Id}"></Label>
	<Label Text="{Binding Name}"></Label>
	</StackLayout>
	</ViewCell>
	</DataTemplate>
	</ListView.ItemTemplate>
	</ListView>
	</StackLayout>

	</ContentPage>

	using System.Linq;
	using LiteDB;
	using Xamarin.Forms;

	namespace DemoLiteDB
	{
	public partial class MainPage : ContentPage
	{

	LiteDatabase _dataBase;
	LiteCollection<Customer> Customers;
	public MainPage()
	{
	InitializeComponent();

	_dataBase = new LiteDatabase(DependencyService.Get<IHelper>().GetFilePath("Banco.db"));
	Customers = _dataBase.GetCollection<Customer>();
	ListCustomers.ItemsSource = Customers.FindAll();
	BindingContext = this;
	}

	}
	}

ADICIONANDO O NUGET PACKAGE

	private void Insert(object sender, System.EventArgs e)
	{

	int idCustomer = Customers.Count() == 0 ? 1 : (int) (Customers.Max(x => x.Id) + 1);
	Customer customer = new Customer
	{
	Id = idCustomer,
	Name = EntryName.Text,
	};

	Customers.Insert(customer);

	ListCustomers.ItemsSource = Customers.FindAll();

	}

	private void Get(object sender, System.EventArgs e)
	{
	Customers = _dataBase.GetCollection<Customer>();

	if (Customers.Count() > 0)
	{
	var customer = Customers.FindAll().FirstOrDefault(x => x.Name == EntryName.Text);
	DisplayAlert("id: " +customer?.Id, "Name: "+customer?.Name, "ok");
	}
	}

	private async void List_Selected(object sender, SelectedItemChangedEventArgs e)
	{
	var action = await DisplayActionSheet("Atenção", "Não", "Sim", "Deletar ?");

	if (action == "Sim")
	{
	var customer = e.SelectedItem as Customer;

	Customers.Delete(customer?.Id);

	ListCustomers.ItemsSource = Customers.FindAll();
	}
	}