如何在vs2012和2013中，为项目引入sqlite linq2db，以及C#操作sqlite的基本知识。

using System; using System.IO; using System.Collections.Generic; using System.Linq; using System.Text; using System.Threading.Tasks; using System.Data.SQLite; namespace ConsoleApplication1 { class Program { static void Main(string[] args) { using (SQLiteConnection conn = new SQLiteConnection("Data Source=d:abc.db")) { conn.Open(); DropTable(conn); CreateTable(conn); InsertData(conn); //GetData(conn); conn.Close(); } } private static void CreateTable(SQLiteConnection conn) { SQLiteCommand cmd = conn.CreateCommand(); cmd.CommandText = @"CREATE TABLE Question( ID integer primary key, QuestionContent text, HtmlContent text)"; cmd.ExecuteNonQuery(); } private static void InsertData(SQLiteConnection conn) { SQLiteCommand cmd = conn.CreateCommand(); StringBuilder sb = new StringBuilder(); for (int i = 0; i < 100; i++) { sb.AppendFormat("INSERT INTO Question (ID,QuestionContent,HtmlContent) VALUES ({0},'试题内容:{1}','试题答案{2}');", i, Guid.NewGuid().ToString(), Guid.NewGuid().ToString()); } cmd.CommandText = sb.ToString(); cmd.ExecuteNonQuery(); } private static void GetData(SQLiteConnection conn) { SQLiteCommand cmd = conn.CreateCommand(); cmd.CommandText = "SELECT * FROM Question"; SQLiteDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { var obj = new { Id = reader.GetInt32(0), QuestionContent = reader.GetString(1), HtmlContent = reader.GetString(2) }; Console.WriteLine(string.Format("Id:{0};QuestionContent={1};HtmlContent={2}", obj.Id, obj.QuestionContent, obj.HtmlContent)); } } private static void DropTable(SQLiteConnection conn) { SQLiteCommand cmd = conn.CreateCommand(); cmd.CommandText = "Drop Table Question"; cmd.ExecuteNonQuery(); } } }