SQLCE

Nuget
Microsoft SQL Server Compact Edition
ErikEJ.SqlCeBulkCopy


Microsoft SQL Server Compact 4.0 is available for download

SQL Server Compact Toolbox
SQL Server Compact Toolbox

Walkthrough: Working with SQL Server Compact in Visual Studio
VS 2010 SP1 and SQL CE
SQL Server Compact 4.0 Tooling Support in Visual Studio 2010 SP1 and Visual Web Developer Express 2010 SP1


SQL Server Compact 4.0 SP1
SQL Server Compact 4.0 線上叢書
SQL 參考 (SQL Server Compact)
SQL Server Compact 與 SQL Server 之間的差異


SQLCE Database C#

在VS2013中使用SQLCE資料庫

Entity Framework 6 & SQL Server Compact 4 (1)–Workflows and tooling
Entity Framework 6 & SQL Server Compact 4 (2)–Easy Private Desktop Deployment
Entity Framework 6 & SQL Server Compact (3)–Getting started with the SQL Server Compact 3.5 provider (and Merge Replication)
Entity Framework 6 & SQL Server Compact 4.0 (4) - Restoring full EF Tools support in Visual Studio 2013
SQL Compact 3rd party tools
Entity Framework 6 (& SQL Server Compact) (5)–Entity Framework 6 extensions
Entity Framework 6 & SQL Server Compact (6)–Entity Framework Reverse POCO Code First Generator
Entity Framework 6 & SQL Server Compact (7) –New features and fixes in version 6.1
Merge Replication with SQL Server Compact 3.5 SP2 and SQL Server 2014 and 2012
Entity Framework 6 & SQL Server Compact (8) –Logging SQL statements
Entity Framework 6 and SQL Server Compact (9) –SqlCeFunctions and DbFunctions

SQL Server Compact Toolbox 3.7–Visual Guide of new features

---

Dapper: An Introduction Dapper Insert Using SQL Compact Edition

我用的Dapper版本是1.13，照上面去做無法成功，需要搭配transaction才能取回Identity。

var sql2 = @"SELECT CAST(@@identity AS BIGINT) as Id ";
var Id = conn.Query<Int64>(sql2, transaction: trans).Single();