Page 1 of 1

Garbage Disposal & DB Schema Versioning

Posted: Wed 22 Oct 2014 12:25
by 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.

Re: Garbage Disposal & DB Schema Versioning

Posted: Thu 23 Oct 2014 14:18
by 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.