Entity Framework

[TravisSpomer]

IvoryTower currently does all database interactions using a set of SQL Server stored procedures through a set of C# wrapper classes. Business logic is split across the wrapper classes and stored procedures.

How would switching to Entity Framework change things?

• Simpler and more standard query code, but more complex business logic?
• Slightly worse performance, presumably?

If you'd want to stop using those stored procedures anyway, is there a database option that would be more productive but a more radical shift? What about Cosmos or another NoSQL option for text-based data?