How to implement web api passing two parameters

Question

Hi , i have a web api like this : public class CardsController : ApiController { [Route("{teamId}/metrics/{memberId}")] public List GetCards(int teamId,int memberId) { //Send the list of cards associated with the team. Also send member previous rating and team average rating of past 7 days throw new NotImplementedException(); } in that given a teamId and memberId it goes to the Vote table and gets last Voted value and last Vote date time and card details also this is my CardData Model : public class CardData { public int CardID { get; set; } public string CardName { get; set; } public string CardDescription { get; set; } public CardRatingData CardRating { get; set; } } and this is CardRatingData Model : public class CardRatingData { public int MemberPreviousRating { get; set; } public DateTime MemberPreviousRatingDateTime { get; set; } public double TeamAverage7DayRating { get; set; } } this is my tables structure :    in that i want to implement using linq to sql stored procedure   please give a code for that.   thank you.

Gowtham K · Accepted Answer

Try this, create procedure sp_getcards ( @TeamID int, @MemberID int ) as begin select Votedvalue, Lastmodifieddate from Vote where TeamID=@TeamID and MemberID=@MemberID end  if you don't want the Card table details,   Assuming there is a relation between Vote and Card table  If you need the Card table details then  follow this,   create procedure sp_getcards ( @TeamID int, @MemberID int ) as begin select v.Votedvalue, v.Lastmodifieddate, c.CardName, .. .. from Vote as v inner join Card as c on v.CardID=c.CardID where TeamID=@TeamID and MemberID=@MemberID end

Gowtham K · Answer

So, there is no foreign key relationship between Vote and card table, am right.

Sivakumar · Answer

is there is a relation between vote and cards table this is a structure like this :

Gowtham K · Answer

Is there is any relationship between vote and the card tables?  can you please share your script or else the schema structure.

Sivakumar · Answer

Please give a stored procedure for that

Gowtham K · Answer

Refer this,   http://www.c-sharpcorner.com/UploadFile/fc9f65/dotnetnuke-module-development-with-kedno-ui-and-web-api/     http://stackoverflow.com/questions/17859543/why-doesnt-web-api-controller-with-linq-to-sql-and-using-statement-work