Change a loadwith from a sql table to a table-valued function RRS feed

  • Question

  • Hi,

    I'm quite new to Linq to SQL. We have some custom code that uses LoadWith (from DataLoadOptions) on another SQL table X.
    Now the schema changed and the data from table X is now retrieved through a table-valued function.

    Any tips on how to rewrite this?

    Thanks in advance!


    Thursday, August 8, 2013 12:51 PM


  • Hi Caroline,

    According to your issue, I suggest you to use Entity Framework 5.

    The Entity Framework is an object-relation mapping framework. It allows developers to work directly with domain-specific objects. It frees the developers to write the storage-specific data-access code. The storage-specific schema can change without changing the application code. The rich query language support allows developers to write complex queries against a conceptual model.

    You can find out more about Entity in Get Started with Entity Framework.

    Best Regards,

    Friday, August 9, 2013 7:02 AM