Question

R

Create a SQLite database in memory and populate it with a built-in dataset of your choice. Then run
some SQL queries on it to show that it works.

Answer 1

Answer:

SqLite database Program:

Public static class SQLite

{

public static void main()

{

using (SQLiteConnection conn = new SQLiteConnection("Data Source=:memory:;")

{

// To open or establish the connection

conn.open();

conn.CreateModule(new SQLiteModuleEnumerable("samplemodule", new string[] {"one","two","three"}));

using (SQLiteCommand comm = conn.CreateCommand())

{

comm.CommentText = Create virtual table t1 using sample module;";

comm.ExecuteNonQuery();

}

using (SQLiteCommand comm = connection.CreateComman())

{

comm.CommandText = "select * from t1;";

using (SQLiteDataReader dataReader = comm.ExecuteReader())

{

while(dataReader.read())

Console.WriteLine(dataReader[0].ToString());

}

}

\\ To close the connection

conn.close();

}

}

}

SQLite queries:

Select Query:-

SELECT DISTINCT column_list

FROM table_list

  JOIN table ON join_condition

WHERE row_filter

ORDER BY column

LIMIT count OFFSET offset

GROUP BY column

HAVING group_filter

Order By clause:

SELECT

column_list

FROM

table

ORDER BY

column_1 ASC,

column_2 DESC;

Distinct clause:

SELECT DISTINCT

column_list

FROM

table;