using Dapper;

using System;

using System.Data;

using System.Data.SqlServerCe;

using System.Linq;

using Newtonsoft.Json;

using DBSearch;

using System.Data.Common;

using System.Data.SQLite;

public class Program

{

    public static void Main()

    {

        var sql = @" select 1 id ";

        using (var Connection = GetSQLiteConnection())

        {

            Connection.Open();

            var result = Connection.Query(sql);

​

​

            Console.WriteLine(JsonConvert.SerializeObject(result));

        }

    }

    static DbConnection GetSQLiteConnection()

{

    var _filePath = "MyDatabaseForDBSearchProject.sqlite";

    var _connectionString = string.Format("Data Source={0};Version=3;",_filePath);

    SQLiteConnection.CreateFile(_filePath);

    var connection = new SQLiteConnection(_connectionString);

    connection.ConnectionString = _connectionString;

    connection.Open();

    #region SQL

    var sql = @"

CREATE TABLE [Table1](

    [col_varchar] [varchar](150) NULL,

    [col_varchar_like] [varchar](150) NULL,

    [col_nvarchar] [nvarchar](300) NULL,

    [col_int] [int] NULL,

    [col_datetime] [datetime] NULL,

    [col_bit] [bit] null,

    [col_null] [varchar],

    [col_float] [float]

);

​

CREATE TABLE [Table2](

    [col_varchar] [varchar](150) NULL,

    [col_varchar_like] [varchar](150) NULL,

    [col_nvarchar] [nvarchar](300) NULL,

    [col_int] [int] NULL,

    [col_datetime] [datetime] NULL,

    [col_bit] [bit] null,

    [col_null] [varchar],

    [col_float] [float]

);

​

insert into [Table1] 

select 'Test','Test','測試',123,'2019-01-02 03:04:05',1,null,1.2 

union all

select 'Test','Test','測試',123,'2019-01-02 03:04:05',1,null,1.2 

;

​

insert into [Table2] 

select 'Test','Test','測試',123,'2019-01-02 03:04:05',1,null,1.2

;   

​

select * from [Table2] 

    ";

    #endregion

    connection.Execute(sql);

    return connection;

}

}