SQLite DateTime比较
SELECT * FROM table WHERE strftime('%s', date) BETWEEN strftime('%s', start_date) AND strftime('%s', end_date)
linq for sqlite的使用方法(C#)
1. 添加引用到工程
System.Data.SQLite
System.Data.SQLite.Linq
2. 修改app.config, 如下:
<??><configuration> <startup useLegacyV2RuntimeActivationPolicy="true"> <supportedRuntime version="v4.0" sku = ".NETFramework,Version=v4.0"/> <supportedRuntime version="v2.0.50727"/> </startup></configuration>
3. 建立与sqlite表对应的实体类:
using System;using System.Collections.Generic;using System.Linq;using System.Text;using System.Data.Linq.Mapping;namespace linq_test{ [Table(Name = "A")] public class A { [Column(Name = "col_1")] public string Col_1 { get; set; } } }
4. 通过DataContext, 编写查询linq to sql
using System;using System.Collections.Generic;using System.Linq;using System.Text;using System.Data.SQLite;using System.Data.Linq;namespace linq_test{ class Program { static void Main(string[] args) { var ctx = new DataContext(new SQLiteConnection( "data source=d:\\test.db")); Table<A> a = ctx.GetTable<A>(); var query = from p in a select p; foreach (var item in query) { System.Console.WriteLine("ID:{0}", item.Col_1); } System.Console.ReadKey(); } }}
【C# SQLite】SQLite 问题集(一)马莎、 FBA解释与实操、 Cdiscount倾情奉献、 新手须知:亚马逊广告入门知识普及、 Tchibo、 中小卖家选品思路、 做好这4个工作,亚马逊A9算法由你掌控!、 怎样才能KO恶意差评?这套组合拳拿去!、
No comments:
Post a Comment