c# 创建sqlite数据库以及表

using System;
using System.Collections.Generic;
using System.Data.SQLite;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

namespace ConsoleApplication1
{
    class Program
    {
        static void Main（string[] args）
        {
            try
            {
                var filename = “D:/testDB.db“;
                SQLiteConnection.CreateFile（filename）;
                Console.WriteLine（“成功建立数据库testDB“）;
                string databasefilename = “D:/testDB.db“;
                string connectionstring = “data source=“ + databasefilename;
                SQLiteConnection dbconnection = new SQLiteConnection（connectionstring）;
                dbconnection.Open（）;
                Console.WriteLine（“成功连接到数据库“）;

                string[] colNames =

 属性            大小     日期    时间   名称
----------- ---------  ---------- -----  ----

    ..A..H.     41472  2020-03-04 13:59  sqlite\.vs\ConsoleApplication1\v14\.suo

    ..A..H.     36352  2020-03-04 14:01  sqlite\.vs\sqlite\v14\.suo

     文件        189  2020-03-04 13:40  sqlite\sqlite\App.config

     文件       5120  2020-03-04 14:01  sqlite\sqlite\bin\Debug\ConsoleApplication1.exe

     文件        189  2020-03-04 13:40  sqlite\sqlite\bin\Debug\ConsoleApplication1.exe.config

     文件      13824  2020-03-04 14:01  sqlite\sqlite\bin\Debug\ConsoleApplication1.pdb

     文件      22688  2020-03-04 14:01  sqlite\sqlite\bin\Debug\ConsoleApplication1.vshost.exe

     文件        189  2020-03-04 13:40  sqlite\sqlite\bin\Debug\ConsoleApplication1.vshost.exe.config

     文件        490  2010-03-17 22:39  sqlite\sqlite\bin\Debug\ConsoleApplication1.vshost.exe.manifest

     文件    1320448  2013-05-23 16:33  sqlite\sqlite\bin\Debug\SQLite.Interop.dll

     文件    1128448  2017-07-18 00:12  sqlite\sqlite\bin\Debug\System.Data.SQLite.dll

     文件        823  2020-03-04 13:49  sqlite\sqlite\obj\Debug\ConsoleApplication1.csproj.FileListAbsolute.txt

     文件       7187  2020-03-04 13:48  sqlite\sqlite\obj\Debug\ConsoleApplication1.csprojResolveAssemblyReference.cache

     文件       5120  2020-03-04 14:01  sqlite\sqlite\obj\Debug\ConsoleApplication1.exe

     文件      13824  2020-03-04 14:01  sqlite\sqlite\obj\Debug\ConsoleApplication1.pdb

     文件        726  2020-03-04 13:45  sqlite\sqlite\obj\Debug\DesignTimeResolveAssemblyReferences.cache

     文件       6998  2020-03-04 14:00  sqlite\sqlite\obj\Debug\DesignTimeResolveAssemblyReferencesInput.cache

     文件        971  2020-03-04 14:01  sqlite\sqlite\obj\Debug\sqlite.csproj.FileListAbsolute.txt

     文件       8160  2020-03-04 14:01  sqlite\sqlite\obj\Debug\sqlite.csprojResolveAssemblyReference.cache

     文件          0  2020-03-04 13:40  sqlite\sqlite\obj\Debug\TemporaryGeneratedFile_036C0B5B-1481-4323-8D20-8F5ADCB23D92.cs

     文件          0  2020-03-04 13:40  sqlite\sqlite\obj\Debug\TemporaryGeneratedFile_5937a670-0e60-4077-877b-f7221da3dda1.cs

     文件          0  2020-03-04 13:40  sqlite\sqlite\obj\Debug\TemporaryGeneratedFile_E7A71F73-0F8D-4B9B-B56E-8E70B10BC5D3.cs

     文件       1860  2020-03-04 13:49  sqlite\sqlite\Program.cs

     文件       1346  2020-03-04 13:40  sqlite\sqlite\Properties\AssemblyInfo.cs

     文件       2968  2020-03-04 13:49  sqlite\sqlite\sqlite.csproj

     文件        985  2020-03-04 14:01  sqlite\sqlite.sln

     目录          0  2020-03-04 13:40  sqlite\sqlite\obj\Debug\TempPE

     目录          0  2020-03-05 10:53  sqlite\.vs\ConsoleApplication1\v14

     目录          0  2020-03-05 10:53  sqlite\.vs\sqlite\v14

     目录          0  2020-03-05 10:53  sqlite\sqlite\bin\Debug

............此处省略13个文件信息