Querying Entity Data Model from C# code

Question

I have an application with an Entity Data Model. I do not completely understand the value of an Entity Data Model. Either way, I know that it connects to my database and interacts with it. I have some C# code from which I want to execute a stored procedure. My problem is, I'm not sure how to do this using the "Entity Data Model" approach.

I'm familiar with the System.Data.SqlClient namespace, but that approach does not seem applicable here. Can someone tell me how to interact with an Entity Data Model sproc via code?

Thanks!

p.campbell · Accepted Answer · 2010-10-27 15:22:54Z

1

Here's a great video tutorial on "Practical Entity Framework for C#"

You can call a stored procedure on SQL Server like this:

myEntities.CalculateCustomerInvoices();

Here's an article on "Using Stored Procedures for Insert, Update & Delete in an Entity Data Model"

answered Oct 27, 2010 at 15:22

p.campbell

101k70 gold badges264 silver badges326 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Pieter van Ginkel · Accepted Answer · 2010-10-27 15:22:51Z

1

This MSDN page explains how to work with stored procedures with the entity framework: http://msdn.microsoft.com/en-us/library/bb896279.aspx.

answered Oct 27, 2010 at 15:22

Pieter van Ginkel

29.7k8 gold badges77 silver badges114 bronze badges

Collectives™ on Stack Overflow

Querying Entity Data Model from C# code

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related