Loading Related data via generated sql script with Entity Framework RRS feed

  • General discussion

  • Hi all,

    I'm working on a report engine so i have to provide a complex search criteria...

    first of all is there any way not to use T-SQL and using LINQ instead?

    and if i have to user T-SQL how can I load related data?

    let me mention that I'm using ExecuteStoreQuery method.

    More info:

    in the UI there would be some dropdown controls which are contains filed names and a number of text boxes that must be filled by user and some other dropdown to make And/Or operator. finally i have to mix them as a criteria for WHERE clause.

    Thanks Friends.

    Friday, September 28, 2012 7:25 AM

All replies

  • Hi Mohammad,

    you could use Entity SQL to dynamically create a query and specify to load related entities.

    Hope it helps.


    Friday, September 28, 2012 9:24 PM