Diego Vega - All Comments

re: Tips to avoid deadlocks in Entity Framework applications

Diego B Vega — Tue, 12 Mar 2013 19:13:08 GMT

Hello Mukesh,

As long as the TransactionScope is created with ReadCommitted and READ_COMMITTED_SNAPSHOT is not enabled in the database then you are not really following the recommendations I explained in this blog post and I assume that you might be seeing locking issues because you are in fact using the default implementation of READ COMMITTED, which uses locking.

While READ COMMITTED and SNAPSHOT are two different transaction isolation levels you can choose from by passing an argument to TransactionScope, READ_COMMITTED_SNAPSHOT setting on the other hand is a database-wide setting that replaces the default implementation of READ COMMITTED which uses locking with one that has READ COMMITTED semantics but uses snapshots.

re: Tips to avoid deadlocks in Entity Framework applications

Mukesh — Tue, 12 Mar 2013 18:26:36 GMT

In the EF code, I have TransactionScope as ReadCommitted Isolation. I set the SNAPSHOT ISOLATION to ON. But READ COMMITTED SNAPSHOT is OFF. I am still facing locking issues. Any ideas?

re: Wrapped System.IO.FileNotFoundException with Entity Framework POCO and Self-Tracking Entities T4 Templates

Gurbax Bhangal — Thu, 14 Feb 2013 12:30:17 GMT

Thanks a lot .......it worked for me

re: Workaround for performance with Enumerable.Contains and non-Unicode columns against EF in .NET 4.0

Felipe Fujiy — Wed, 19 Dec 2012 11:52:21 GMT

Diego, one thing that always bite me, is how to encapsulate Filters. Sometimes I do a extension method:

public static IQueryable<EDIFICIO> WhereFromProject(this IQueryable<EDIFICIO> source, int idProject)

{

return andares.Where(x=> x.prj == idProject);

}

But it just works on main collection like container.EDIFICIO.WhereFromProject(idProject) and not on subqueries: container.AnotherEntity.Where(x=> x.EDIFICIO. WhereFromProject(idProject))

Is it possible to do something similar usaing Expressions and MethodInfo as you did? Could you send me a example? Would help so much.

Thx

re: Wrapped System.IO.FileNotFoundException with Entity Framework POCO and Self-Tracking Entities T4 Templates

Diego B Vega — Fri, 30 Nov 2012 19:37:13 GMT

@Peter Doyle: yes this is fixed in the EF 5 templates for Visual Studio 2012.

re: Wrapped System.IO.FileNotFoundException with Entity Framework POCO and Self-Tracking Entities T4 Templates

Peter Doyle — Thu, 29 Nov 2012 14:47:31 GMT

But it literately 2 years later and the same bug is still there!

Maybe its fixed in the 2012 VS

re: Stored procedures with output parameters using SqlQuery in the DbContext API

Diego B Vega — Tue, 11 Sep 2012 23:20:50 GMT

Crob, thanks for sharing this detail. I didn't test this with different versions of SQL Server so I didn't hit a problem with the missing EXEC. I will add a note to the post.

re: Stored procedures with output parameters using SqlQuery in the DbContext API

Crob — Tue, 11 Sep 2012 19:13:31 GMT

Found the solution here:

stackoverflow.com/.../what-causes-incorrect-syntax-near-stored-procedure-name-in-ef-code-first-and

re: Stored procedures with output parameters using SqlQuery in the DbContext API

Crob — Tue, 11 Sep 2012 18:13:48 GMT

I am using this against a sql2008 server and it's working great for me. I need to get the application to work against a sql2000 server but when I try it I get the exception "Incorrect syntax near 'stored procedure name here'." If I build the query string myself without using parameters it goes through fine like below:

var spResults = context.Database.SqlQuery<GoldmineCustomerInfo>("spweb20_GetCustomerInfoFromGoldMine @custCode = 'custcodevalue').ToList();

Do I have to tell EF this is a sql2000 server in my configuration somewhere?

re: Wrapped System.IO.FileNotFoundException with Entity Framework POCO and Self-Tracking Entities T4 Templates

Wil Wiseman — Fri, 03 Aug 2012 16:27:53 GMT

I thought my EF framework was hosed and was about to uninstall VS and re-install. I didn't excpect the SE to return any results when fed the exception, so applaud you thoroughness. Well done!