SQL可视化工具_可视化工具tableau

 <connectionStrings>
    <add name="SQLiteCon" connectionString="Data Source=D:\DBFile\SQLite\Test.db;Version=3" providerName="System.Data.SQLite" />
  </connectionStrings>

        public void SQLiteMethod()
        {
            using (DbBase db = CreateDB.CreateDbBase())
            {
                //新增列
                int a = db.Execute(@"ALTER TABLE Student ADD 'SEX' varchar");

                //删除列 
                //1.首先根据Student表创建一张新表Student2
                //2.然后我们删除Student这个表
                //3.将Student2这个表重命名为Student
                var tran = db.DbTransaction;
                int b1 = db.Execute(@"CREATE TABLE Student2 as select ID,NAME,ADDRESS FROM Student ", tran);
                int b2 = db.Execute(@"DROP TABLE if exists Student ", tran);
                int b3 = db.Execute(@"ALTER TABLE Student2 rename to Student ", tran);

                if (b1 == 0 && b2 == 0 && b3 == 0)
                {
                    tran.Commit();
                }
                else
                {
                    tran.Rollback();
                }

                //增
                int index = db.Execute(@"INSERT INTO Student(ID,NAME,ADDRESS)
                                         VALUES(1, '李四', '东方明珠') ");
                //删
                int index2 = db.Execute(@"DELETE FROM Student WHERE ID = 1 ");

                //改
                var updateSql = "UPDATE Student SET NAME='李白' WHERE ID=@ID";
                bool res = db.Update<Student>(updateSql, new { ID = 1 });

                //查
                string selectSql = @"SELECT * FROM Student ";
                var student = db.Query<Student>(selectSql);

                //批量插入
                bool resBatch = db.InsertBatch<Student>(student);
            }
        }