Saturday, April 2, 2011

Problem in mapping fragments starting at line nnn:All the key properties (xxxx.column) of the EntitySet xxxx must be mapped to all the key properties

Problem:

Error 3003: Problem in mapping fragments starting at line 257:All the key properties (table.column) of the EntitySet table must be mapped to all the key properties (table.column, table.column) of table table.


Solution:

Select the column giving you problems, hit F4 for properties, and change Nullable from (None) to False.




















Posted by at
Labels: , ,

3 comments:

  1. AnonymousAugust 10, 2011 at 10:28 AM

    Thanks

    ReplyDelete
  2. AnonymousApril 6, 2012 at 5:57 AM

    Thanks Great Work ...:)

    ReplyDelete
  3. UnknownOctober 3, 2013 at 5:33 AM

    Old blog post and very little activity, but in the event that someone gets here as a result of searching for 'Shape2SQL not creating table', I've found a solution. You need to change the database's compatibility level to 'SQL Server 2008 (100)' in Database Properties -> Options -> Compatibility Level. Spatial data features were introduced to SQL Server in the 2008 version and are not compatible with earlier versions from what I can gather.

    ReplyDelete

Subscribe to: Post Comments (Atom)