Write Sql stored procedure with EF code first approach?

Question

Hello.

I am new with EF6 and I'm doing some tests with the ASP.NET MVC 5 and Code First.

As a beginner, I’m confused.

If I create model classes and then have the database (sqlserver) created by EF, can I then write stored procedures in the sqlserver database? I mean with Sql Server Management Studio.

If I change the sql server instance (for example from development to production ) do I have to rewrite them on the new sqlserver?

Answer 1

Yes. You will need to recreate them. You can manually add them, or create c# code to create them and add to the EF on model creating.