Entity Framework 6 - Knowledge Base (KB)
99 results for: in tag: stored-procedures
Linq To Sql vs Entity Framework Performance
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 call a Stored Procedure from an EntityDataSource?
(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
Entity Framework Error: "The container 'XXXX' specified for the FunctionImport could not be found in the current workspace."
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
Entity Framework stored procedure not available
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
IQueryable<> from stored procedure (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
Cannot execute stored procedure with ADO.NET Entity Framework
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
Returning a DataTable using Entity Framework ExecuteStoreQuery
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
Refreshing a stored procedure in entity framework 3.5
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
What causes "Incorrect syntax near <stored procedure name>" in EF Code First and SQL 2005?
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
Entity Framework stored procedure with multiple resultsets?
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
Calling a WCF DataService [WebGet] function from the client
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
Entity Framework Stored Procedure Table Value Parameter
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
Does Entity Framework Code First support stored procedures?
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
Mapping select stored procedures in entity framework
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
How to use Entity Framework with Stored procedures and POCOs
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
Why Mysql Stored Procedure Parameter not found 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
EF4.1 Code First: Stored Procedure with 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
How to pass Parameters to Stored Procedure from Entity Framework?
I want to know how to send parameters to stored procedure from entity framework? Thanks in advance.
asked by Satish Nissankala
Use stored procedure in Entity Framework (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
Scalar Value from stored procedure via Entity Framework
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
Page 1 of 5
