Xamarin SQLite

SQLite-net
SQLite-net PCL Nuget

SQLite in Mobile Development

Xamarin.Android Data Access
Create a Database with SQLite

iOS Data Access
Create a Database with SQLiteNET

Case Study: Tasky
Tasky Sample
Todo Sample

Xamarin.FormsでSQLiteのDBを埋め込んでアプリを配布する
Deploying a database file with a Xamarin.Forms app

SQLite資料庫使用
開放資料跨平台應用程式開發 使用SQLite資料庫

Connection

SQL Server Connection Strings for ASP.NET Web Applications

SqlConnection.ConnectionString 屬性
OracleConnection.ConnectionString 屬性

連接字串語法

connection pooling

講解SQL 連線字串中關於Persist Security Info 參數的用途

[WinForm]Windows程式(非網頁)，如何從app.config檔讀取資料庫連結字串（ConnectionString）

How to Test a SQL Connection from any Windows Machine

[ASP.net] 利用SQL Server的活動監視器(圖形化介面)瞭解Connection Pool運作

how to see active SQL Server connections?

SELECT DB_NAME(dbid)AS DBName
     , COUNT(dbid)AS NumberOfConnections
     , loginame AS LoginName
     , hostname
FROM sys.sysprocesses
WHERE dbid > 0
GROUP BY dbid , loginame , hostname;

SQLite參考

Using the SQLite database engine with Windows Phone 8 apps
[EntLib]微軟企業庫5.0 學習之路——第三步、為項目加上異常處理（採用自定義擴展方式記錄到數據庫中）
使用log4net完成程序異常日誌記錄（使用SQLite數據庫記錄和普通文本記錄）

Make your SQLite bulk inserts very fast in C# .NET
Improve performance of SQLite bulk inserts using Dapper ORM

SQLite Performance and Prepared Statements

SQLite in WPF with Entity Framework 6

Cross-Platform SQLite Support – Part 1

SQLitePCL Now Supports Universal Windows Apps!

Windows Phone 8.0, Phone 8.1, Windows 8.1–Experiments Accessing SQLite

Local Database SQLite For Windows 10

Android高效入門—SQLite資料庫

SQLite基础学习

---

Telerik OpenAccess ORM

ASP.NET 4.0 連結 SQLite 設定

初學SQLite，筆記一下。
1.先安裝NuGet

2.用NuGet安裝System.Data.SQLite，這樣是選擇x86和x64都有的版本

3.若要使用ASP.NET的membership provider和role provider功能，可安裝TechInfoSystems.Data.SQLite
web.config設定方式與DB檔可參考此篇：SQLite Membership, Role, and Profile Providers

4.連結資料庫，若懶得自己寫code，可安裝Enterprise Library Data Access Application Block

5.若要在Visual Studio裡面直接管理SQLite DB，或需要設計介面，可到SQLite網站上下載Precompiled Binaries for .NET

6.我的web.config設定，其中有一個DbProviderFactories是參考SQLite readme設定的，不然EntLib的DAAB不會動

<?xml version="1.0" encoding="utf-8"?>
<!--
  如需如何設定 ASP.NET 應用程式的詳細資訊，請造訪
  http://go.microsoft.com/fwlink/?LinkId=169433
  -->
<configuration>
  <configSections>
    <!-- EnterpriseLibrary Configuration -->
    <section name="dataConfiguration" type="Microsoft.Practices.EnterpriseLibrary.Data.Configuration.DatabaseSettings, Microsoft.Practices.EnterpriseLibrary.Data, Version=5.0.505.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35" requirePermission="false" />
  </configSections>
  <!-- EnterpriseLibrary defaultDatabase -->
  <dataConfiguration defaultDatabase="DefaultConnection">
    <providerMappings>
      <add databaseType="Microsoft.Practices.EnterpriseLibrary.Data.GenericDatabase, Microsoft.Practices.EnterpriseLibrary.Data, Version=5.0.505.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35" name="System.Data.SQLite" />
    </providerMappings>
  </dataConfiguration>
  <connectionStrings>
    <add name="DefaultConnection" connectionString="Data Source=|DataDirectory|app_data.sqlite;Version=3;" providerName="System.Data.SQLite" />
  </connectionStrings>
  <system.data>
    <!-- SQLite Data Provider -->
    <DbProviderFactories>
      <remove invariant="System.Data.SQLite" />
      <add name="SQLite Data Provider" invariant="System.Data.SQLite" description=".Net Framework Data Provider for SQLite" type="System.Data.SQLite.SQLiteFactory, System.Data.SQLite" />
    </DbProviderFactories>
  </system.data>
  <system.web>
    <compilation debug="true" targetFramework="4.0" />
    <authentication mode="Forms" />
    <!-- Membership provider -->
    <membership defaultProvider="SQLiteMembershipProvider">
      <providers>
        <clear />
        <add applicationName="SQLite ASP.NET Provider" passwordFormat="Clear" minRequiredNonalphanumericCharacters="0" minRequiredPasswordLength="2" maxInvalidPasswordAttempts="2" enablePasswordReset="true" enablePasswordRetrieval="true" passwordAttemptWindow="10" requiresQuestionAndAnswer="false" requiresUniqueEmail="false" connectionStringName="DefaultConnection" name="SQLiteMembershipProvider" type="TechInfoSystems.Data.SQLite.SQLiteMembershipProvider, SQLiteMembershipProvider" />
      </providers>
    </membership>
    <!-- Role provider -->
    <roleManager enabled="true" cacheRolesInCookie="true" cookieProtection="Validation" defaultProvider="SQLiteRoleProvider">
      <providers>
        <clear />
        <add applicationName="SQLite ASP.NET Provider" connectionStringName="DefaultConnection" name="SQLiteRoleProvider" type="TechInfoSystems.Data.SQLite.SQLiteRoleProvider, SQLiteMembershipProvider" />
      </providers>
    </roleManager>
    <!-- Profile provider -->
    <profile defaultProvider="SQLiteProfileProvider">
      <providers>
        <clear />
        <add applicationName="SQLite ASP.NET Provider" connectionStringName="DefaultConnection" name="SQLiteProfileProvider" type="TechInfoSystems.Data.SQLite.SQLiteProfileProvider, SQLiteMembershipProvider" />
      </providers>
    </profile>
  </system.web>
  <runtime>
    <assemblyBinding xmlns="urn:schemas-microsoft-com:asm.v1">
      <dependentAssembly>
        <assemblyIdentity name="System.Data.SQLite" publicKeyToken="db937bc2d44ff139" culture="neutral" />
        <bindingRedirect oldVersion="0.0.0.0-1.0.82.0" newVersion="1.0.82.0" />
      </dependentAssembly>
    </assemblyBinding>
  </runtime>
</configuration>

----- Android SQLiteDatabase