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 = new string[] { "ID", "Name", "Age", "Email" };
                string[] colTypes = new string[] { "INTEGER", "TEXT", "INTEGER", "TEXT" };
                string tableName = "table1";
                string queryString = "CREATE TABLE IF NOT EXISTS "   tableName   "( "   colNames[0]   " "   colTypes[0];
                for (int i = 1; i < colNames.Length; i  )
                {
                    queryString  = ", "   colNames[i]   " "   colTypes[i];
                }
                queryString  = "  ) ";
                SQLiteCommand dbCommand = dbconnection.CreateCommand();
                dbCommand.CommandText = queryString;
                SQLiteDataReader dataReader = dbCommand.ExecuteReader();

                Console.WriteLine("成功建立一个表");




                Console.ReadKey();

            }
            catch (Exception ex)
            {
                Console.WriteLine(ex.Message.ToString());
                Console.ReadKey();
            }
        }
    }
}