Sql Query:
Linq Query:
SELECT convert(varchar,[addedat],103) as addedat FROM tblTable
Linq Query:
var query = from q in entity.tblTable
select new
{
date = SqlFunctions.DateName("day", q.addedat).Trim() + "/" +
SqlFunctions.StringConvert((double)q.addedat.Value.Month).TrimStart() + "/" +
SqlFunctions.DateName("year", q.addedat),
};