SQL Query to Linq

Hi,

Please refer this links,

https://entityframework.net/knowledge-base/26146606/how-can-i-convert-datetime-to-string-in-linq-query-

https://stackoverflow.com/questions/19778672/format-date-in-linq-query-result

+1

Hi,

Try this

https://www.c-sharpcorner.com/UploadFile/3d39b4/an-mvc-application-with-linq-to-sql/

+1

HI

You can do this way.

var objFuels = from item in _db.Fuels
select new{ item.EntryDate, item.EntryDate.toString('yyyy-MM-dd'), item.EntryDate.DayOfWeek}

Complete tutorials

https://www.tutorialspoint.com/linq/linq_sql.htm

+2

Have you tried Linqer http://www.sqltolinq.com An SQL-> LINQ converter Or LINQPad http://www.linqpad.net/

+1