Disappointed with Linq to Entity :-(

We have a scenario where in we have to check for the existence of User Information in a database (residing in production SQL Server) other than the application database. We are using LINQ to Entities as our data cum business layer (Isn’t that what it should be ???). Since I have to get the information from another database (or server rather) I didnt want to create another entity set so I just created a stored proc in my application database to check for that (we have linked server set up so just took 2 mins to write the SP). Now I cannot use the written stored procedure in my L 2 E since it is not returning any entity as such :-(. I searched online and could not find any direct methods to do so. We have to work around to make this happen. I hope they fix this in the forth coming releases. Do you guys know of any direct method by which I can make use of a function import which does not return a value or a scalar value?

Happy Programming!!!



0 Responses to “Disappointed with Linq to Entity :-(”

  1. Leave a Comment

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

%d bloggers like this: