Delpin Susai Raj Wednesday 6 February 2019

Xamarin.Forms - SQLite Database CRUD Operations

In this blog post, you will learn how to use SQLite 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.

SQLite


  1. SQLite is a Light weight database that implements a small, fast, self-contained, high-reliability, full-featured, SQL database engine. 
  2. SQLite is the most used database in the world. It is built into all mobile phones.



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-SQLite

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.


  • sqlite-net-pc


Add sqlite-net-pc NuGet

Go to Solution Explorer and select your solution. Right-click and select "Manage NuGet Packages for Solution". Search "sqlite-net-pc" and add Package. Remember to install it for each project (.NET Standard, Android, iO, and UWP).



Create a Model

In this step, you can create a model for 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 SQLite Connection and create the table in SQLiteHelper.cs constructor.

SQLiteHelper.cs





Read All

Now, write the code to read all data from SQLite Database.

SQLiteHelper.cs



MainPage.Xaml.cs



Click the Play button to try it out.



Insert

Now, write the following code to insert data into SQLite Database.





Click the Play button to try it out.




Read

Now, write the following code to read data from SQLite Database.




Click the Play button to try it out.




Update

Now, write the following code to update data to SQLite Database.




Click the Play button to try it out.




Delete

Now, write the following code to delete data from SQLite Database.




Click the Play button to try it out.




Full code

SQLiteHelper.cs



MainPage.Xaml.cs




I hope you have understood, how to use SQLite Database with CRUD Operations in Xamarin.Forms. Thanks for reading. Please share your comments and feedback.

Happy Coding :)

22 comments:

  1. This comment has been removed by the author.

    ReplyDelete
  2. This comment has been removed by the author.

    ReplyDelete
  3. Thank you so much for sharing this excellent information. Your article is amazing. Good to discover your post

    Hire Xamarin Developer Texas, USA

    ReplyDelete
  4. I was reading some of your content on this website and I conceive this internet site is really informative ! Keep on putting up. data sciences

    ReplyDelete

  5. Thanks of sharing this post…Python is the fastest growing language that helps to get your dream job in a developing area. It says every fundamental in a programming, so if you want to become an expertise in python get some training





    Dot Net Training in Chennai | Dot Net Training in anna nagar | Dot Net Training in omr | Dot Net Training in porur | Dot Net Training in tambaram | Dot Net Training in velachery






    ReplyDelete
  6. Thanks for sharing this informative content , Great work
    Leanpitch provides online training in Scrum Master during this lockdown period everyone can use it wisely.
    CSM online certification

    ReplyDelete
  7. Thanks for sharing. I am facing runtime error. Could you please help me out ?

    ReplyDelete
  8. Thanks for sharing this informative content , Great work
    Devops Online Training
    Leanpitch provides online training in Devops during this lockdown period everyone can use it wisely.

    ReplyDelete

  9. Thanks for sharing this.,
    Leanpitch provides crash course in Facilitating change everyone can use it wisely.
    Facilitating change

    Facilitating change in the workplace

    ReplyDelete
  10. please tutorial for back up and restore sqlite database with xamarin

    ReplyDelete

  11. Thank you cooperative!
    Definitely one favorite post.
    Soon you can quickly download all the crack software Latest [2021]
    Please visit!
    I think you will see this software. Visit our website: -
    ===============================================
    Softcracks.Info
    =================================================
    Wallpapers HD & 4K Backgrounds
    SQLite Expert Professional
    PhoneRescue
    Magic DVD Copier
    Windows 7 Loader Activator
    MyLanViewer
    BlueStacks Premium 5
    WinUtilities Pro

    ReplyDelete
  12. Does your WiFi range extender keep showing the red light? Well, ignoring this issue can put an adverse effect on your extender from degrading its performance to losing connection and ultimately the range extender. So before a big mishap happens, troubleshoot this issue as soon as possible.mmywifiext.net login

    ReplyDelete
  13. Your Blog Is Nice. It has all information about software. Thanks for Shearing!
    See Hear

    ReplyDelete
  14. Xamarin Monkeys: Xamarin.Forms - Sqlite Database Crud Operations >>>>> Download Now

    >>>>> Download Full

    Xamarin Monkeys: Xamarin.Forms - Sqlite Database Crud Operations >>>>> Download LINK

    >>>>> Download Now

    Xamarin Monkeys: Xamarin.Forms - Sqlite Database Crud Operations >>>>> Download Full

    >>>>> Download LINK P6

    ReplyDelete
  15. Xamarin Monkeys: Xamarin.Forms - Sqlite Database Crud Operations >>>>> Download Now

    >>>>> Download Full

    Xamarin Monkeys: Xamarin.Forms - Sqlite Database Crud Operations >>>>> Download LINK

    >>>>> Download Now

    Xamarin Monkeys: Xamarin.Forms - Sqlite Database Crud Operations >>>>> Download Full

    >>>>> Download LINK M8

    ReplyDelete
  16. Very very Nice Blog thanks for sharing this amazing information with us,https://countrysidegreens.com/

    ReplyDelete