Hi,

I m trying to build a web site which will use ENTITY DATA MODEL for database interactions. I have added some stored procedures to the entity model. But I can only access those stored procedures which returns entity set. All other SPs which return "scalar" or "none" are not accessible in the code.

 This procedure was simple and straight forward in LINQ to SQL. Where we could access all the stored procedures (irrespective of return type) directly in our code behind as methods.

Can we extend the entity classes to expose those SPs to the code behind. Or is there any other solution?

Please help !!

lucky1983:

 I have added some stored procedures to the entity model. But I can only access those stored procedures which returns entity set. All other SPs which return "scalar" or "none" are not accessible in the code.

 I think u want to do something like this...

 esUtility e = new esUtility(); 

object alerts = e.ExecuteScalar("Booking", "spGetHotelAlerts", parameters); 

return alerts.ToString(); 

Hi,

Thank you for your reply. Actually I know very little about "esUtility". Is this an external utility? (external to microsoft?) I dont have permission to use any third party tool or utility in our project. Can you give some more information about "esUtility".

Thanks

Lucky

u said u are using ENTITY DATA MODEL...? let me confirm that u r usinf the entity spaces right? if yes then esUtility is part of it.u have to write using EntitySpaces.Interfaces;
using EntitySpaces.Core; to access it... wel l let me know if  i can help u in this direction.

Actually I m using ADO .NET entity data model which is a part of .net framework version 3.5. I guess "esUtility" is a different thing.

BR

Lucky

Hi,

Actually I am using ADO .Net Entity Data Model which is a part of .net framework 3.5. I guess it is different than "esUtility".

BR

Lucky

lucky1983:

Actually I m using ADO .NET entity data model which is a part of .net framework version 3.5. I guess "esUtility" is a different thing.

BR

Lucky

For questions related to ADO.NET Entity Framework and LINQ to Entities, I suggest you to ask them here to get a quicker and better reply.

Thanks.

Hey thanks for ur reply. I have posted this topic in the "Ado .net entity framework and linq entities" forum. link for this thread is:

http://social.msdn.microsoft.com/Forums/en-US/adodotnetentityframework/thread/3f55039c-754c-41db-a116-2c915ebdf41b/

 Hope this problem will solve quickly.

 Thanks,

Lucky