EF4 table function substitute where a view isn't possible RRS feed

  • Question

  • Suppose I have a CLR object in the database that calls webservices on remote machines. To make the problem even more complex, the CLR object includes logic to decide which web service to use based on parameters passed to its exposed method.

    I can wrap the call in a table function or a stored procedure, but not in a view; the result set is technically infinite. I'd like to use EF for reads for this type of operation, but I believe table functions are not supported in EF4 and that stored proc calls are only supported for Inserts, Updates, and Deletes but not Reads.

    I can always bypass EF4 for this type of operation, but is there an Entity Framework friendly solution to my problem?

    Friday, August 19, 2011 4:03 PM