Entity framework and stored procedure with output parameter returning row (EF will receive complex type)

complextype entity-framework-6 output-parameter row stored-procedures

Question

I am using entity framework 6 with stored procedures. Currently I deal with this problem:

Ideally I need to get data from one stored procedure. This data includes: One Conversation (basic info) + multiple Clients (which are engaged in this conversation) + Messages from Conversation.

I think that output parameters is right way to do, but i am stuck.

So, how can I do that? And is this the right way to get rows of different data from stored procedure? I am trying to avoid a solution where I would be sending recurring data about conversation with every row of the client.

1
0
6/26/2014 9:44:42 AM

Fastest Entity Framework Extensions

Bulk Insert
Bulk Delete
Bulk Update
Bulk Merge

Popular Answer

You can try with 

static void Main(string[] args)
{
  using (SchoolEntities context = new SchoolEntities())
  {
    var outputParameter = new ObjectParameter(“sum”, typeof(decimal));
    context.SchoolBudgetForDateRange(new DateTime(2007, 1, 1), 
      new DateTime(2008, 1, 1), 
      outputParameter);
    Console.WriteLine(outputParameter.Value);
  }
}

where SchoolBudgetForDateRange is a stored procedure

more info here

0
1/29/2015 6:24:47 PM

Related Questions

Code-First Entity Framework w/ Stored Procedure returning results from complex Full-text Searches

Posting this as an answer rather than an edit to my question:...Taking some of the insight provided by @Drauka's (and google) here is what I did for my initial iteration....Created the stored procedure to do the full text searching. It was really too complex to be done in EF even if supported (as one example some of my entities are related via busi...
c# entity-framework full-text-search stored-procedures
asked by Matthew

Database.SqlQuery calling stored procedure that has multiple output parameters

I have a stored procedure like below which takes 1 input parameter ( Name ) and returns 2 output parameters( EmployeeId and Salary). Our stored procedure will insert Name into Employee table and give us back EmployeeId and Salary....CREATE PROCEDURE dbo.insertemployee @iName varchar(500), @OEmployeeId int OUTPUT, @OSalary Money OUTPUT ...We are u...
code-first entity-framework
asked by Ziggler

Executing a stored procedure that returns a result set and has output parameters with Entity Framework

It turns out that the output parameters aren't available until all results are read. I fixed my problem by appending ....ToList()... to the tend of the ...ExecuteFunction()... call. I figured it out by browsing the metadata in Visual Studio. You can see the relevant documentation here: ...I don't see this mentioned in the actual documentation on...
c# entity-framework entity-framework-6 stored-procedures
asked by Tim Coker

Incorrect Syntax Near '0' - when using sp_executeSQL to execute stored procedure with output parameter

Actual Stored Procedure is...ALTER Procedure [dbo].[ApplyList] @oldlist int, @username varchar(50), @newlist int, @errormessage varchar(2000) output AS BEGIN SET NOCOUNT ON; SET @errormessage = ''; END ...Here is the SQL code generated by Entity Framework 6.1 and using Database First approach....declare @p6 varchar(2000); set @p6=N...
entity-framework-6 sp-executesql sql-server
asked by manu97

Calling Oracle stored procedure using Entity Framework with output parameter?

I have a simple Oracle stored procedure that gets three parameters passed in, and has one output parameter:...CREATE OR REPLACE PROCEDURE RA.RA_REGISTERASSET ( INPROJECTNAME IN VARCHAR2 ,INCOUNTRYCODE IN VARCHAR2 ,INLOCATION IN VARCHAR2 ,OUTASSETREGISTERED OUT VARCHAR2 ) AS BEGIN SELECT INPROJECTNAME || ', ' || INLOCATION |...
c# entity-framework entity-framework-6 oracle oracle-manageddataaccess
asked by Donny

How to retrieve output parameter from stored procedure by EF code first

i am new in EF and working with EF code first. just got a link ...https://code.msdn.microsoft.com/How-to-retrieve-output-e85526ba... which show how to use read output type param by EF db first. so anyone tell me how to retrieve output parameter from stored procedure by EF code first ?...if possible give me small sample code or redirect me to releva...
c# entity-framework stored-procedures
asked by Monojit Sarkar

Entity Framework 6 code-first stored procedure map to complex objects

How do I use a stored procedure to get a parent and its children?...A generic version of my code is this:...public class Parent { public Int32 ParentId { get; set; } public Guid ParentGuid { get; set; } public String Name { get; set; } public virtual ICollection<Child> Children { get; set; } } public class Child { public Int32 ...
c# ef-code-first entity-framework-6 stored-procedures
asked by ScubaSteve

Calling insert stored procedure using entity framework that has return parameter

I am writing a logic for inserting record using Entity Framework store procedure that will return an int parameter that is TeamId. I have created the function import for the store procedure. Please see the screenshot below...I am not sure how to return the int parameter. Please see the code below...DataAccess layer...public int InsertTeam(string co...
asp.net-web-api entity-framework-6
asked by Tom

how to call stored procedure in EF6 with output parameters

You can implement the following to retrieve the data for a stored procedure call ...using(var db = new iConext()) { var details = db.Database.SqlQuery<iType>("exec iProc @param", new SqlParameter("@param", iValue)); } ...iType... is int or string or long or can be a ComplexType...@param... is one or more required parameters...iContext... is fo...
asp.net-mvc entity-framework-6 output-parameter stored-procedures string
asked by Pradip

No Complex Type created from new stored procedure, EF database first

I can not figure out why EF6 will not create a complex type for my stored procedure. I am using the database-first approach. ...I created a new stored procedure in SSMS 2017. Open my EDMX, right clicked "Update Model From Database," check my stored procedure and finish. ...In my Model Browser, I see my stored procedure, but no complex type was crea...
complextype entity-framework-6 sql-server stored-procedures tsql
asked by Ben-Coden

Fastest Entity Framework Extensions

Bulk Insert
Bulk Delete
Bulk Update
Bulk Merge
View more on Stack Overflow

Prime Library

Performance

Expression Evaluator

More Projects...

Related

Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow
Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow