Response 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.

Revision 2
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.