EDM, SQLServer, the Strange and Wonderful
After working with EDM from MS – specifically the 3.5 version on the Visual Studio 2008 designer, I’m impressed . . . but I did find a weird bug. The EDM engine accepted a malformed table name with high-order bit ascii character in the table name. Once it munched on this, it went bezerk causing all sorts of mischief. I correct the table name, updated the model and removed the old entity and association from the model. In its’ defense, EDM tried to tell me that there was problem – but I didn’t figure it out very quickly. The table in question was named HostIPAddress, and EDM mapped it to an Entity named ‘Host_IPAddress’. Since I edited the table through the SqlServer graphical editor, the table looked just fine to me. Once I looked at the SQL itself, it appeared that the table name was ‘Host IPAddress’ (note the space). All is well now . . .
Did you enjoy this post? Why not leave a comment below and continue the conversation, or subscribe to my feed and get articles like this delivered automatically to your feed reader.
Comments
No comments yet.
Leave a comment