Garbage Disposal & DB Schema Versioning
Posted: Wed 22 Oct 2014 12:25
Details:
Hi.
I'm looking for some advice on best practice for handle Linq DataContexts - SQL Server.
1. Should encapsulate dbcontext creation in a using statement? or should I wait for garbage collection?
2. I am not using EF so no access to "Migrations" features, i understand I can use dbForge to create schema diffs + update scripts and add to source control. The real question is whats the best way to execute those in a "up/down" version mechanism for application updates?
Appreciate any suggestions you may have.
Thanks
Dan.
Hi.
I'm looking for some advice on best practice for handle Linq DataContexts - SQL Server.
1. Should encapsulate dbcontext creation in a using statement? or should I wait for garbage collection?
2. I am not using EF so no access to "Migrations" features, i understand I can use dbForge to create schema diffs + update scripts and add to source control. The real question is whats the best way to execute those in a "up/down" version mechanism for application updates?
Appreciate any suggestions you may have.
Thanks
Dan.