Unable to excute database query due table name is the same as T-Sql keyword

[sharpcoder7]

Hello! I begin dig this good project and found an issue. If I have table [Order] massive throws an exception because the table name is a t-sql keyword. So in all requests we need to use [Order] instead of Order. So I think the solution will be a creating of HashSet of t-sql keywords and check table name before it will be inserted into a query. Possible another easiest solutions exists?

ps I cant rename the table because another software uses this database .

[amirrajan]

Can you give me some sample code? Are you using DynamicDb or DynamicRepository?

[sharpcoder7]

dynamic db = new DynamicDb();
var all = db.Order.All();

[amirrajan]

Just change this line: https://github.com/amirrajan/Oak/blob/master/Oak/DynamicDb.cs#L30 to

var tableName = "[" + callInfo.Name + "]";

The source code should be under a folder called /Oak in your project.

[sharpcoder7]

sorry but this will not work. In method TableExists. we quering .Query("select name from sysobjects where name = @0", table) if table name will contain square brackets like [DailySettlements] then this script returns zero record. program will fail due table [DailySettlements] is not exists

[amirrajan]

Hmm, maybe just put "[" + tableName + "]" around this line? https://github.com/amirrajan/Oak/blob/master/Oak/DynamicDb.cs#L39

[amirrajan]

You could also add table.Replace("[", "").Replace("]", "") here: https://github.com/amirrajan/Oak/blob/master/Oak/Association.cs#L1031