Get data from multiple table by using single func in webapi

Laxmi Katti

8y5.2k.NET

I have to write a single query or stored procedure or function which can display all tables data using ASP.Net WEB API.

Please help me to to find solution.

public class StudentController : ApiController

{

EmployeeDbEntities1 entities=new EmployeeDbEntities1();

public IEnumerable Get()

{

List ListStud = new List();

var query = (from a in entities.tblstudents

select a).ToList();

query.ForEach(s =>

{

ListStud.Add(new Students

{

StudId = s.StudentId,

StudName = s.Name,

StudAdd = s.Address,

StudGender = s.Gender,

StudStd = s.Standard

}

);

}

);

return ListStud;

}

[Route("~/api/User")]

public List get()

{

List users = new List();

var query = (from a in entities.tblUsers

select a).ToList();

query.ForEach(u =>

users.Add(new User { username = u.UserName, password = u.Password }

)

);

return users;

}

4 Replies

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

Ramesh Palanivel8y ago
Accepted answer
Hi Lakshmi,

You can achieve this using three ways,

1. Linq with Entity objects
2. Table Joins with stored procedure
3. Manually getting record using Id with Linq or Stored Procedure.

Please share some sample data with table names, I will help you.
Laxmi Katti8y ago
I want to write a function it take table as parameter instead of writing same code for eveytime i should call one function that return table data .
Ramesh Palanivel8y ago
Hi lakshmi,

Please confirm whether you are expecting the below result?
public class ViewResult
{
public int id{get;set;}
public string name{get;set;}
public string address{get;set;}
public string standard {get;set;}
public string gender{get;set;}
public int teacherid{get;set;}
public string teachername{get;set;}
public string subject{get;set;}
public string address{get;set;}
}
Laxmi Katti8y ago
table students with (studId,Name,address,standard,gender)
table teacher with (Id,Name,subject,address)
please i am new to .net fresher please help me.