Passing Non Entity Data to Stored Procedure

Question

I want to Pass Non Entity Parameters to Stored Procedures. Actually I have 3 Tables in Database. Table 1: Contact -> ContactID, Name Table 2: Images-> ImageId, Image and Table 3 ContactsImages: ContactId,ImageId,isDefault.

Now when I Insert/Update Contact I also want to update other 2 tables and I want to do it with Stored Procedure to avoid server trips. To Serve above purpose I need to pass almost all the parameters from all three tables. But I dont know how to do it in Entity Framework. I tried to create New Model with All the Parameters But I don't have table to map the Model.  Can anyone please show me the solution or is there any work around to solve this.

thanks for your time and help...

Answer 1

 <http://blogs.msdn.com/b/alexj/archive/2009/11/07/tip-41-how-to-execute-t-sql-directly-against-the-database.aspx>

 

It also means you can execute a sproc too and pass parms to the sproc/

 

Answer 2

Hi ertejaspatel,

Welcome to MSDN Forum.

darnold924 have provided you a good link which can solved the issue. In Entity Framework, it is possible to access the sqlConnection and sqlCommand, then you can do query by T-SQL or stored procedure through normal ADO.NET.

Best Regards

---

Allen Li [MSFT]
MSDN Community Support | Feedback to us