Fetching data from ADO.NET Entity Model + Stored Procedure

Question

0.00/5 (No votes)

See more:

, +

Hi,
I am new to ADO.NET Entity Model,I need to fetch data from more than 2 tables using store procedure + function import method or any other type,
I am currently using function import + SP to fetch the data from only one table.
Please help me in this

Thank you in advance

Posted 22-Oct-13 0:19am

ravithejag

Add a Solution

Comments

Nandakishore G N 22-Oct-13 6:51am

if you are using single table use entity object and if multiple tables use complex object

ravithejag 22-Oct-13 7:55am

Thank u

Nandakishore G N 22-Oct-13 7:59am

if it is concluded.Please , close the question by changing status solved.
So that others can get help from this question.

2 solutions

Solution 1

C#

con = new SqlConnection();
con.ConnectionString = ConfigurationManager.ConnectionStrings["StudentConnectionStr"].ConnectionString;
con.Open();
DataSet ds = new DataSet();
SqlParameter sp=new SqlParameter("@sid",value);
ds = SqlHelper.ExecuteDataset(con, CommandType.StoredProcedure, "Getstudentdetail", sp);
dt = ds.Tables[0];

Posted 22-Oct-13 0:31am

Atul Pachori

Updated 22-Oct-13 0:35am

v2

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

ravithejag · Accepted Answer · 2013-10-22T18:27:00

Solution 2

By using complex object i am able to fetch the data from more than 2 tables

Posted 22-Oct-13 18:27pm

ravithejag

Fetching data from ADO.NET Entity Model + Stored Procedure

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0

Fetching data from ADO.NET Entity Model + Stored Procedure

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0

Existing Members

...or Join us