zzz projects Entity Framework 6 EF 6
Home EF Core Articles Knowledge Base Online Examples
  • Home
  • EF Core
  • Articles
  • Knowledge Base
  • Online Examples

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...
entity-framework linq-to-sql performance stored-procedures
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...
asp.net entity-framework stored-procedures
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 ...
.net ado.net entity-framework stored-procedures vb.net
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 = ...
entity-framework stored-procedures
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...
c# entity-framework stored-procedures
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...
.net entity-framework iqueryable linq-to-entities stored-procedures
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
entity-framework stored-procedures
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...
code-first ef-code-first entity-framework stored-procedures
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, ...
entity-framework odata stored-procedures wcf
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...
c# code-first entity-framework stored-procedures
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...
entity-framework stored-procedures visual-studio-2008
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...
code-first ef-code-first entity-framework sql-server-2005 stored-procedures
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 ...
asp.net c# entity-framework stored-procedures
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..
c# ef-code-first entity-framework stored-procedures table-valued-parameters
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...
ef-code-first entity-framework parameters stored-procedures
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...
entity-framework stored-procedures
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.
entity-framework parameters stored-procedures
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...
c# entity-framework poco stored-procedures
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...
.net c# entity-framework linq stored-procedures
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...
c# entity-framework mysql stored-procedures
asked by Bilgehan

Page 1 of 5
  • 1
  • 2
  • 3
  • 4
  • 5
  • »

Prime Library

Performance

  • Entity Framework Extensions
  • Entity Framework Classic
  • Bulk Operations
  • Dapper Plus

Expression Evaluator

  • C# Eval Expression
  • SQL Eval Function
More Projects...

Related

  • EF Extensions Online Benchmark
  • WIN an EF Extensions license
  • EF6 BatchSaveChanges for only $79
Save your entities 20× faster with EF Extensions
SaveChanges vs BulkSaveChanges

EF Extensions
Try for free now
Get monthly updates by subscribing to our newsletter!
SUBSCRIBE!