Garbage Disposal & DB Schema Versioning

[danjus10]

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.

[Shalex]

1. We recommend you to employ the using statement to dispose unmanaged resources after the DataContext object finishes its work.

2. LinqConnect doesn't include any embedded features which are similar to the Entity Framework Migrations functionality.