Quote:
I have tried "Generate Database From Model" tool but it will generate only tables and it does not generate store procedures and views in sql server which is present in edmx, why?
Ask the people who created the tool - there are several different ways to do this as Google will easily show you.
We have no idea which tool you used, so we couldn't tell you "do this" if we wanted to!