Sqlite database utilites class

Question

I am using SQlite as a database in a C# winforms application.

My project involves some select simple queries, inserts, deletes.

Currently, I have written all these sql, Ado.net queries in the codebehind.

For eg:

   private void frmPlant_Load(object sender, EventArgs e)
    {
        FillData();
    }
    void FillData()
    {
        dataGridView1.AutoGenerateColumns = true;
        string query = @"SELECT * FROM  [Table1]";

        using (SQLiteConnection conn = new SQLiteConnection(connString))
        {
            conn.Open();
            da = new SQLiteDataAdapter(query, conn);
            ds = new DataSet();
            da.Fill(ds, "T1");
            dt = ds.Tables[0];
            dataGridView1.DataSource = ds;
            dataGridView1.DataMember = "T1";
            dataGridView1.Columns["TId"].HeaderText = "SNo";
            dataGridView1.Columns["Tcode"].Visible = false;
            dataGridView1.Columns["TID"].Width = 50;
            dataGridView1.Columns["Tcode"].Width = 70;
        }
    }

I have quiet a bit of code like this which interacts with the DB.

Question: Instead of writing these ado.net connections, sql query in the code behind, I want to use a 2 tier/3tier architecture. This should involve writing all the database stuff(ado.net execute scalar, reader, sql queries in another DBUtilitesclass/project and simply calling this DBUtilitesclass from the code behind.

Please suggest any tutorials to do this.

PS: I am using sqlite which does not support stored procedures.

Thank u Sun

If you are going to 2/3 tier design, then why not also consider ORM like Fluent NHibernate, github.com/jagregory/fluent-nhibernate/wiki/Getting-started? — Lex Li
– Lex Li, Commented May 20, 2012 at 8:23

Deepu Madhusoodanan · Accepted Answer · 2012-05-20 07:28:20Z

1

Refer

http://www.switchonthecode.com/tutorials/csharp-tutorial-writing-a-dotnet-wrapper-for-sqlite

http://snipplr.com/view/41708/

http://www.codeproject.com/Articles/22165/Using-SQLite-in-your-C-Application

Hope this helps

Thanks

Deepu

answered May 20, 2012 at 7:28

Deepu Madhusoodanan

1,5151 gold badge15 silver badges26 bronze badges

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

Collectives™ on Stack Overflow

Sqlite database utilites class

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related