Alternative to How entity framework work in instead of a complex store procedure in sql server. and how EF is work with big project. if a project contain more than 2000 table .Is it possible to work with EF.
In EF if you can use stored procedure also by adding stored procedures in EF.Create strode procedure in SQL server and update your edmx file.You can now call your stored procedure as a function in EF.
Returning Multiple Result Sets from an Entity Framework Stored Procedure with Function Import Mappings