C#/SQLCE CREATE TABLE programmatically(自增+主键)

Question

我正在尝试以编程方式在 SQL CE 数据库中创建一个表。目前，我正在使用以下查询 - 尽管出现错误；

string command = @"CREATE TABLE CONNECTION(" +
                  "connection_id INTEGER IDENTITY(1,1) PRIMARY KEY, " +
                  "host NVARCHAR(255), port INT, key NVARCHAR(50), " +
                  "last_used NVARCHAR(15));";

我得到的错误是:

There was an error parsing the query. [ Token line number = 1, Token line offset = 104, Token in error = key ]

我似乎无法弄清楚我做错了什么。我习惯了 MySQL，查询略有不同。

Answer 1

尝试将 key 括在方括号中

string command = @"CREATE TABLE CONNECTION(" +
                        "connection_id INTEGER IDENTITY(1,1) PRIMARY KEY, " +
                        "host NVARCHAR(255), port INT, [key] NVARCHAR(50), " +
                        "last_used NVARCHAR(15));";

• Reserved Words