I'm new to Entity Framework, and currently developing an MVC 5 application with Code-First Entity Framework 6.1.2.
I need to write custom reports. Instead of writing complex linq, I can write a couple quick Stored Proc's and write the results to CSV. Can I call these procs with EF? or would I just be better off using ADO.NET?
I know I can do:
var data = db.Database.SqlQuery<ReportDetailed>("sp_rpt_report @reportType @endDate, @startDate", parameters).ToList<ReportDetailed>();
But I would need to build a rather large model for each report result, and that seems like a lot of work for little reward and wrong.