SQLite在线教程:http://www.runoob.com/sqlite/sqlite-syntax.html
与SQLserver区别:https://www.cnblogs.com/tianboblog/p/4200685.html
主要是:
查询时把两个字段拼接在一起
--sqlserver--
select Filed1+'@'+Filed2 from table
--sqlite--
select Filed1||'@'||Filed2 from table
取前几条数据
--sqlsever--
SELECT TOP 10 * FROM table ORDER BY filed DESC
--sqlite--
select * from table limit 0,10
ASP.NET操作SQLite的Demo源码下载:
https://download.csdn.net/download/djk8888/11102179