[Solved]-C# string to number, TryParse returns true when Parse fails-LINQ,C#

you can't perform tryparse on the sql server, but if you are not doing further selection criteria, then you can try pulling the data from sql as it is and then parsing on the client.

eg

myresults = mydatacontext.mydbfunction()
double note;

var list =(from a in myresults
select new 
{
   a.id,
   a.nom,
   a.prenom,
   a.moyenne,
}).tolist();


var finalresults = (from a in list 

select new mainreportmodel()
{
   id = a.id,
   lastname = a.nom,
   firstname = a.prenom,
   average = a.moyenne,
   result = double.tryparse(a.moyenne.trim(), numberstyles.number,    cultureinfo.invariantculture, out note) ? (double.parse(a.moyenne.trim(), numberstyles.number, cultureinfo.invariantculture) < 4 ? "failed" : "success") : a.moyenne
}