How do you create an SQLite Database with c# in Visual Studio?

Question

I am creating an SQLite Database in Visual Studio with Xamarin in C#.

I should note that this is for android only.

From what I understand, in this class I must create the SQLite Database, and make it so I am able to add, delete, and retrieve data.

I should also note that there is a separate class to call the methods in this class.

I am very new to this and I am not sure how to do this.

I've read tutorials, I've watched hour long videos, and I still am not able to figure out this.

Any help would be greatly appreciated.

This is the class template I am using and must follow:

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;

using Android.App;
using Android.Content;
using Android.OS;
using Android.Runtime;
using Android.Views;
using Android.Widget;

using BB.Mobile.Models;

namespace BB.Mobile
{
    /// <summary>
/// A class to provide a single interface for interacting with all SQLite data operations for stored tracking points.
/// </summary>
class DataManager
{
    /// <summary>
    /// Will compile and return all matching unsynchronized ping data from the SQLite database.
    /// </summary>
    /// <returns></returns>
    public List<PingGroup> GetUnsynchronizedPings()
    {
        List<PingGroup> unsynchronizedPings = new List<PingGroup>();

        // TODO: Retrieve all unsynchronized pings from the SQLite database and return them to the caller.

        return unsynchronizedPings;
    }

    /// <summary>
    /// Insert a single ping group into the SQLite ping database.
    /// </summary>
    /// <param name="pingGroup"></param>
    public void AddUnsynchronizedPing(PingGroup pingGroup)
    {
        // TODO: Add the passed ping group parameter into the SQLite database as new/unsynchronized.


    }

    /// <summary>
    /// Mark all open and unsynchronized pings in the database as synchronized.
    /// </summary>
    public void SetAllPingsSynchronized()
    {
        // TODO: Delete all database data or set it as synchronized using a flag.

    }
}
}

Did you read this? erikej.blogspot.dk/2014/10/…

ErikEJ
– ErikEJ

2015-04-05 11:46:18 +00:00
Commented Apr 5, 2015 at 11:46 — ErikEJ
– ErikEJ, Commented Apr 5, 2015 at 11:46

Jason · Accepted Answer · 2015-04-05 19:34:45Z

2

The SQLite Component has pretty clear documentation - is there something specific you don't understand?

using SQLite;
// ...

public class Note
{
    [PrimaryKey, AutoIncrement]
    public int Id { get; set; }
    public string Message { get; set; }
}

// Create our connection
string folder = Environment.GetFolderPath (Environment.SpecialFolder.Personal);
var db = new SQLiteConnection (System.IO.Path.Combine (folder, "notes.db"));
db.CreateTable<Note>();

// Insert note into the database
var note = new Note { Message = "Test Note" };
db.Insert (note);

answered Apr 5, 2015 at 19:34

Jason

89.5k15 gold badges137 silver badges151 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

MindRoasterMir Over a year ago

Hi. I just want to ask, if we can keep any extension of the created file or it must have to be fileName.db (i.e. .db). Thanks in advance

Jason Over a year ago

I don’t believe the extension matters

Collectives™ on Stack Overflow

How do you create an SQLite Database with c# in Visual Studio?

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related