Sep 142008
As I was wiring up a project to use SubSonic I ran into a problem with my tables using reserved words.
SubSonic Reserved Words Error:
1: . colvarApplicationId.DefaultSetting = @"(newid())";
If you get the “Character is not valid” error as in the line above..there is a reserved word somewhere in your table
My database only contained the tables required for the .NET Role Provider and one user defined table. After telling SubSonic to only build classes for my table my project compiled at run time using the .abp without issue. I have not done enough testing to verify if there is an incompatibility here or just something funky in my code. I’m currently leaning towards incompatibility because I would never mess-up..er..um..I mean being that its a brand new project
