C#中关于SQLite中跨库对比筛选数据

跨库连接表语句

string attach = "attach database A.db as A"

string select = "select colName from B.tableName colName not in(select col from A.tableName)

B.db:
SQLiteCommand cmd = new System.Data.SQLite.SQLiteCommand(conn);
                cmd.CommandText = attach;
                cmd.ExecuteNonQuery();
                if (DBset.Tables.Contains(dataTableName))
                    DBset.Tables[dataTableName].Clear();
                cmd.CommandText = select;
                SQLiteDataAdapter dbAdapter = new SQLiteDataAdapter(cmd);
                dbAdapter.Fill(DBset, dataTableName);