Exception: Dynamic SQL generation for the UpdateCommand is not supported against a SelectCommand that does not return any key column information RRS feed

  • Question

  • I've read somewhere that even if we don't have a primary key, we can define a schema programmatically that considers a particular column, primary key. Can this be done? I've already read suggested 5 articles which came up with the same solution that is to add a primary key. I want to know that if this can be done by explicitly selecting a row as a primary key via code.

    • Moved by KJian_ Friday, September 25, 2009 8:27 AM (From:SQL Server XML)
    Thursday, September 24, 2009 6:35 AM


All replies