Entity Framework 6 - Knowledge Base (KB)
99 results in tag: stored-procedures
Performance of Linq To SQL versus Entity Framework
I have been searching for recent performance benchmarks that compare L2S and EF and couldnt find any that tested calling stored procedures using the released version of EF. So, I ran some of my own tests and found some interesting results....Do these resu...
asked by Vyrotek
Can I use an EntityDataSource to invoke a Stored Procedure?
(ASP.net 3.5, C#, SQL Express 2008)...I want to have a Web Form, where I can search for "Solutions" (my table) using a keyword entered by the user and after the result comes back and populates a GridView. ...I already have parts of this search via a store...
asked by miccet
ADO.NET Entity Framework cannot run stored procedures.
I've created a simple parameterless stored procedure which I've pasted below. I've imported the stored procedure to my Entity Model and created a Function Import. The function in the model is never created and I am unable to execute this stored procedure ...
asked by ShawnCBerg
"The container 'XXXX' supplied for the FunctionImport could not be located in the current workspace," says an Entity Framework error.
I am executing this... EntityConnection entityConnection = (EntityConnection)context.Connection; EntityCommand command = entityConnection.CreateCommand(); command.CommandText = "Genesis.AL_Insert"; command.CommandType = ...
asked by Jedi Master Spooky
A stored procedure in Entity Framework is not accessible.
I added a reference to a stored procedure in my edmx file, then right clicked on it and selected "Create Function Import", it was added to the Function Imports folder under EntityContainer in the model browser....As I understand it I should be able to use...
asked by jhunter
From a stored procedure, IQueryable> (entity framework)
I want to get ...IQueryable<>... result when executing stored procedure. ...Here is piece of code that works fine: ...IQueryable<SomeEntitiy> someEntities; var globbalyFilteredSomeEntities = from se in m_Entities.SomeEntitiy where se.Glob...
asked by arena-ru
Multiple resultsets in an Entity Framework stored procedure?
I am new to EF4 ....I am using a stored procedure that returns 2 resultsets? I understand that this is not possible and not supported.Pity!...What is the workaround? any code examples?...Thanks a lot
asked by user9969
Using Entity Framework ExecuteStoreQuery to return a DataTable
I am working with a system that has many stored procedures that need to be displayed. Creating entities for each of my objects is not practical. ...Is it possible and how would I return a ...DataTable... using ...ExecuteStoreQuery... ?...public ObjectResu...
asked by detroitpro
Client-side call to a WCF DataService [WebGet] function
I have an EF4 model with a stored procedure that I want to call from the client. The server code looks like this:...[WebGet] public IQueryable<SalesData> GetSalesReport(int reportType, int yr, int m, int d) { DateTime dt = new DateTime(yr, m, ...
asked by Ronny
Is stored procedures supported by Entity Framework Code First?
I've watched several presentations of EF Code First and haven't seen how EFCF works with stored procedures....How can I declare a method that will use some sp? Can I pass an entity to a method that calls sp without manually mapping entity properties to sp...
asked by frennky
In entity framework 3.5, you may refresh a stored method.
I am using .NET 3.5 SP1, VS 2008 with the entity framework. I originally added a stored procedure to my model which took 2 parameters. Later, I changed the sproc to just take 1 parameter. I ran the ...Update Model From Database... menu option and confirme...
asked by Jeff
In EF Code First and SQL 2005, what causes "Incorrect syntax at stored procedure name>"?
The examples for System.Data.Entity.Database.SqlQuery method I've found appear to work well with SQL 2008 R2 but do not appear to work with SQL 2005....This call will work with SQL 2008 R2:...var myEntities = dbContext.Database.SqlQuery<MyEntity>("GetData...
asked by Dan Mork
In entity framework, mapping selected stored procedures
My scenario I'm using Visual Studio 2010 with Entity Framework 4.1 I have a legacy database with many tables and many stored procedures. I'm writing an ASP.NET C# program using MVC 3...I have adopted the 'database first' design using ADO.NET DbContext so ...
asked by Mark_Gibson
Value Parameter for Entity Framework Stored Procedure Table
I'm trying to call a stored procedure that accepts a table value parameter. I know that this isn't directly supported in Entity Framework yet but from what I understand you can do it using the ...ExecuteStoreQuery... command off of the ...ObjectContext..
asked by Nick Olsen
First, in EF4.1, create a stored procedure with an output parameter.
I use Entity Framework 4.1 Code First. I want to call a stored procedure that has an output parameter and retrieve the value of that output parameter in addition to the strongly typed result set. Its a search function with a signature like this...public I...
asked by Sebastian Weber
Entity Framework scalar value from stored procedure
I have found a few articles like this one: ...http://devtoolshed.com/using-stored-procedures-entity-framework-scalar-return-values...Yet when I take the step to create a function import for a int32 scalar, this is what gets generated:... public ObjectResu...
asked by Roger
How can I use Entity Framework to provide parameters to a stored procedure?
I want to know how to send parameters to stored procedure from entity framework? Thanks in advance.
asked by Satish Nissankala
How to utilize Entity Framework with POCOs and Stored Procedures
I am trying here to use Entity Framework with Stored procedures and POCOS and 2 different projects....I have one project DataAccess (for my edmx and DataContexts) and one project BusinessEntities (for my POCOs).... DataAccess have a reference of BusinessE...
asked by Erick
In Entity Framework, use stored procedures (code first)
I use this code to define my stored procedure...CREATE PROCEDURE [dbo].[SP] (@Country NVARCHAR(20)) AS BEGIN SET NOCOUNT ON; SELECT c.*,O.* from Customers as c inner join orders O on c.CustomerID=o.CustomerID where c.Country=@Cou...
asked by Mahdi jokar
Why is there no Mysql Stored Procedure Parameter in the collection?
I have problem with entity framework and mysql. I have solved entity framework function parameters problem with ...this answer...But when I want to add some data with mysql stored procedure I have ...Parameter 'kick_Prod_StateID' not found in the collecti...
asked by Bilgehan
