In this blog post , you will learn how to use LiteDB Database with CRUD Operations in Xamarin.Forms.
Introduction
Xamarin.Forms code runs on multiple platforms - each of which has its own filesystem. This means that reading and writing files is most easily done using the native file APIs on each platform. Alternatively, embedded resources are a simpler solution to distribute data files with an app.
LiteDB
- LiteDB is serverless database. fully written in C# code.
- LiteDB stores documents in the BSON (Binary JSON) data format like MongoDB.
- LiteDB is a simple and fast NoSQL database. use to build Mobile, Desktop and small web applications.
Prerequisites
- Visual Studio 2017 or Later(Windows or Mac)
Setting up a Xamarin.Forms Project
Start by creating a new Xamarin.Forms project. You’ll learn more by going through the steps yourself.or download source here
https://github.com/susairajs/XamarinForms-LiteDB
Visual Studio 2019 has more options in the opening window. Clone or check out the code from any repository or, open a project or solution for your computer.
Now, you need to click "Create a new project".
Now, filter by Project Type: Mobile
Choose the Mobile App (Xamarin. forms) project under C# and Mobile.
Name your app. You probably want your project and solution to use the same name as your app. Put it on your preferred location for projects and click "Create".
Now, select the blank app and target platforms - Android, iOS and Windows (UWP).
Subsequently, go to the solution. In there, you get all the files and sources of your project (.NET Standard). Now, select XAML page and double-click to open the MainPage.Xaml page.
You now have a basic Xamarin.Forms app. Click the Play button to try it out.
Setting up the User Interface
Go to MainPage.Xaml and write the following code.
MainPage.xaml
Click the Play button to try it out.
NuGet Packages
Now, add the following NuGet Packages.
- LiteDB
Add LiteDB NuGet
Go to Solution Explorer and select your solution. Right-click and select "Manage NuGet Packages for Solution". Search "LiteDB" and add Package. Remember to install it for .NET Standard project.
Create a Model
In this step, you can create a model to Create a Table.
Person.cs
Get Local File Path
Now, Write the following code to get local file path for storing the database in App.xaml.cs
App.xaml.cs
Create a Table
In this step, Write the following code to create a LiteCollection and create the table in LiteDBHelper.cs constructor.
LiteDBHelper.cs
Check Database
if you need to explore your LiteDB database download LiteDBViewer
https://github.com/falahati/LiteDBViewer/releases
Example
Read All
Now, write the code to read all data from LiteDB Database.
LiteDBHelper.cs
MainPage.Xaml.cs
Click the Play button to try it out.
Insert
Now, write the following code to insert data into LiteDB Database.
Click the Play button to try it out.
Read
Now, write the following code to read data from LiteDB Database.
Click the Play button to try it out.
Update
Now, write the following code to update data to LiteDB Database.
Click the Play button to try it out.
Delete
Now, write the following code to delete data from LiteDB Database.
Click the Play button to try it out.
Full code
LiteDBHelper.cs
MainPage.Xaml.cs
I hope you have understood, how to use LiteDB Database with CRUD Operations in Xamarin.Forms. Thanks for reading. Please share your comments and feedback.
Happy Coding :)
i am using xamarin forms. how to access the litedb from android emulator
ReplyDeletethis the path i am getting /data/user/0/org.mohi/files/MohiSocialWorker.db
Thanks for sharing this informative content , Great work
ReplyDeleteLeanpitch provides online training in Scrum Master during this lockdown period everyone can use it wisely.
CSM online