how to get data in property class while using EDMX.

Omprakash Amarwal

Hello

i am using database first approach in my project. my question is that when we are us store procedure in edmx then edmx will generate property class according to first select command of the store procedure. if we have conditional multiple select query's in store procedure. so how would be edmx will decide to generate property class and fill the results in fields.

i am getting error while store procedure will execute second or third select command.

i am sure that edmx will take only first select command fields and generates property fields accordingly.

6 Replies

Know the answer? Post it — somebody with the same question will find it here.

Omprakash Amarwal10y ago
still you did't understand my question. i know sp will return data according to action but. if action will'second' or'third' then how edmx will get data. try it then you will face the exact error.
Bikesh Srivastava10y ago
hi,
yes you are doing good.
procedure return data according your @action input value.
use procedure in your code and pass parameter as per your input.
Omprakash Amarwal10y ago
step 1: create a store procedure like this.
create procedure GetDataTest
(
@action varchar(10)
)
as begin
if(@action='first')
begin
select * from Story
end
if(@action='second')
begin
select * from story_file_mapping
end
if(@action='third')
begin
select * from Wallet
end
end
here is three select query's each query have different fields.
step 2: add it into Edmx.
step 3: then call store procedure with parameter action.
Bikesh Srivastava10y ago
can you share your part of code.
Omprakash Amarwal10y ago
yes that's ok that we can only get first select statement. but my question is how to get conditional select query's data in property class.
got it..
Bikesh Srivastava10y ago
Hi,
Yes definetily you can select first value.
use .firstordefault property.
or visit link:- http://www.entityframeworktutorial.net/crud-operation-in-connected-scenario-entity-framework.aspx