I want to the controller in my sql query

Here is my controlller n above the first i put the sql function which i created.but in table Allocation filed data type is int so i have to convert that in double.

i want sql query which i display after execplian the things after write.

That function how to write in my controller plz guide me.   

SELECT SID, RID, Schema_Name, SType, InvestmentType, Allocation, Lum_Sum_Amount, Allocation /100.0 * Lum_Sum_Amount as total FROM Schema_Details where RID = 1 

this is my controller with method.....

public ActionResult recommendedportfolio()
{
using (var db = new WFTradeEntities())
{
return View(db.Schema_Details.ToList());
}
}
[HttpPost]
public ActionResult recommendedportfolio(int sName)
{
using (var db = new WFTradeEntities())
{
var total = db.Schema_Details.Where(x => x.RID == sName)
.Select(x => new
{
Rid = x.RID,
Amount = Convert.ToDouble(x.Lum_Sum_Amount),
Allocation = Convert.ToDouble(x.Allocation),
total = ((x.Allocation / 100) * x.Lum_Sum_Amount)
}).ToList();
return PartialView("_PortfolioTable", total);
}
}

and I am getting this error how can i solve it..

1 Reply

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

Abhilash J A9y ago
Hello,

From the error it sounds like one of the variables you're converting to a double is already one in the DB. Any chance one of the lum_sum_amount is null. So you cannot use Convert.ToDouble there.

You cannot use any kind of Function calls within your lambda expressions, What you can do is first get the plain data into a object list and then run your own logic to change the data into desired format. Idea is to keep Linq and the Data conversion logic in 2 different steps.