SQLite With Xamarin iOS

In this article, you will learn how to Create a SQLite DataBase in Xamarin iOS, using Xamarin Studio.

Introduction

Xamarin is a platform to develop cross-platform and multi-platform apps (for example, Windows phone, Android, iOS). In Xamarin platform, the code sharing concept is used. In Xamarin Studio, Visual Studio is also available.


Browse Code Here.


Prerequisites

• Xamarin Studio.
• Xcode.

The steps given below are required to be followed in order to Create a Create a SQLite DataBase in Xamarin iOS, using Xamarin Studio.

Step 1

Go To Xamarin Studio.
Click New Solution—> select iOS—>select App--> Choose single View App. Afterwards, click Next.

Step 2

In this step, configure your app. Give the app name (Ex:sample), Organization Identifier. Afterwards, click Next.

Step 3

In this step, give your project name (Ex: Sample) and solution name (Ex: Sample). Give the path of your project. Afterwards, click Create.

Step 4

Subsequently, go to the solution. In the solution, get all the files and sources in your project. Now, select Main.storyboard and double click to open Main.storyboard page.

Step 5

After opening the Main.storyboard, you can design this page, as per your desire.

Step 6

In this step design your app.using storyboard and Toolbox.

1. Button(btnCreateDB)
2. Label(lblDbName)
3. Label(lblDbPath)

Step 7

In this step add one Package in your project.

• sqlite.net

Go to Solution Explorer—>Package—>Add Package.

Now Choose  sqlite.net  and select Version. Afterwards, click Add Package.

Step 8

In this step, add one class file name called (Student.cs).
This class is called Student Table.

Step 9

In this step, go to the Student.cs page. write the code given below.

Student.cs

using System;
using SQLite;

namespace XamariniOSSQLite
{
 public class Student
 {
  [PrimaryKey,AutoIncrement]
  public int id { get; set; }
  public string Name { get; set;}
  public string Age { get; set;}
 }
}

Step 10

In this step, go to the ViewController.cs page. write the code given below.

ViewController.cs

using System;
using UIKit;
using System.IO;
using SQLite;

namespace XamariniOSSQLite
{
 public partial class ViewController : UIViewController
 {
  public static string DbName = "SQLitedb.db3";
  public static string DbPath =Path.Combine(Environment.GetFolderPath(Environment.SpecialFolder.MyDocuments),DbName);
  protected ViewController(IntPtr handle) : base(handle)
  {
   // Note: this .ctor should not contain any initialization logic.
  }

  public override void ViewDidLoad()
  {
   base.ViewDidLoad();
   // Perform any additional setup after loading the view, typically from a nib.
  }

  partial void BtnCreate_TouchUpInside(UIButton sender)
  {
   CreateDB();
  }

  public void CreateDB()
  {
   try
   {
    var db = new SQLiteConnection(DbPath);
    db.CreateTable();

    lblDBName.Text = "DB Name:" + DbName;
    lblPath.Text = "DB Path:" + DbPath;
   }
   catch (Exception e)
   {
    Console.WriteLine(e);
   }

  }

  public override void DidReceiveMemoryWarning()
  {
   base.DidReceiveMemoryWarning();
   // Release any cached data, images, etc that aren't in use.
  }
 }
}

Step 11

Now, go to Run option , choose Debug and the list of iPhone and iPad simulators, which are available. You can choose any one simulator and run it.

Output

After a few seconds, the app will start running on your iPhone simulator.You will see your app working successfully.

You can click Create BD button .

Now The SQLite DataBase will be Created Successfully.

Summary

This was the process of how to Create a SQLite DataBase in Xamarin iOS , using Xamarin Studio.