linq串連sqlite資料庫(linq to sqlite) .net3.5

標籤：查詢   key   sqlite   arch   com   elf   any   value   ted   

http://www.cnblogs.com/xianyin05/archive/2012/12/23/2829905.html

using Models;using System;using System.Collections.Generic;using System.Data.SQLite;using System.Diagnostics;using System.Linq;using System.Text;namespace Demo2{    class Program    {        static void Main(string[] args)        {            //Program p = new Program();            SqliteDataContext db = new SqliteDataContext(@"Data Source=MyDatabase.sqlite;Version=3;");  //建立串連            //var str = db.highscores.Where(u=>u.score>3000).ToList();            db.Log = Console.Out;            var temp1 = db.GetTable<highscores>().ToList();                        var temp = db.GetTable<highscores>();            var result = from n in temp select n;            foreach (var item in result)            {                Console.WriteLine(item.name);            }            Console.ReadKey();        }        //資料庫連接        SQLiteConnection m_dbConnection;        public Program()        {            createNewDatabase();            connectToDatabase();            createTable();            fillTable();            printHighscores();        }        //建立一個空的資料庫        void createNewDatabase()        {            SQLiteConnection.CreateFile("MyDatabase.sqlite");        }        //建立一個串連到指定資料庫        void connectToDatabase()        {            m_dbConnection = new SQLiteConnection("Data Source=MyDatabase.sqlite;Version=3;");            m_dbConnection.Open();        }        //在指定資料庫中建立一個table        void createTable()        {            string sql = "create table highscores (name varchar(20), score int)";            SQLiteCommand command = new SQLiteCommand(sql, m_dbConnection);            command.ExecuteNonQuery();        }        //插入一些資料        void fillTable()        {            string sql = "insert into highscores (name, score) values (‘Me‘, 3000)";            SQLiteCommand command = new SQLiteCommand(sql, m_dbConnection);            command.ExecuteNonQuery();            sql = "insert into highscores (name, score) values (‘Myself‘, 6000)";            command = new SQLiteCommand(sql, m_dbConnection);            command.ExecuteNonQuery();            sql = "insert into highscores (name, score) values (‘And I‘, 9001)";            command = new SQLiteCommand(sql, m_dbConnection);            command.ExecuteNonQuery();        }        //使用sql查詢語句，並顯示結果        void printHighscores()        {            string sql = "select * from highscores order by score desc";            SQLiteCommand command = new SQLiteCommand(sql, m_dbConnection);            SQLiteDataReader reader = command.ExecuteReader();            while (reader.Read())            {                Console.WriteLine("Name: " + reader["name"] + "\tScore: " + reader["score"]);            }            Console.ReadLine();        }    }}

using Models;using System;using System.Collections.Generic;using System.Data;using System.Data.Linq;using System.Data.Linq.Mapping;using System.Data.SQLite;using System.Linq;using System.Text;namespace Demo2{    public class SqliteDataContext : DataContext    {        public SqliteDataContext(string connection, MappingSource mappingSource) :            base(connection, mappingSource)        {        }        public SqliteDataContext(IDbConnection connection, MappingSource mappingSource) :            base(connection, mappingSource)        {        }        public SqliteDataContext(string connectionString) :            base(new SQLiteConnection(connectionString))        {        }        public SqliteDataContext(IDbConnection connection) :            base(connection)        {        }        //public virtual DbSet<highscores> highscores { get; set; }    }}

using System;using System.Collections.Generic;using System.Data.Linq.Mapping;using System.Linq;using System.Text;namespace Models{    [Table(Name = "highscores")]  //特性表示將highscores類與資料庫中名稱為highscores的表    public class highscores    {        //[Column(IsPrimaryKey =true)]        [Column]  //特性則對應資料庫中的列        public string name { get; set; }        [Column]        public int score { get; set; }    }}

 

linq串連sqlite資料庫(linq to sqlite) .net3.5