Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
ferrethouse
Constraint Violating Yak Guru
352 Posts |
 Posted - 2014-06-09 : 18:26:31
|
| How many of you DBAs are stuck working in an environment where LINQ and/or the Entity Framework are used? I fully appreciate that these things make the lives of developers much easier but I'm regularly running into scenarios where application performance is suffering because LINQ is being translated into sub-optimal TSQL. In fact, I've just been told by a developer that the "StartsWith" LINQ construct that is being translated into a CHARINDEX = 1 instead of a LIKE 'blah%' is a known limitation and there is no workaround. My index is being ignored because of this.Frustration mounting....... |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2014-06-09 : 18:44:32
|
This was a huge problem at my last job. I tried to make stored procedures a requirement but lost that battle. Thankfully I'm now in an environment where the DBAs do have the power. I'm much happier.  Tara KizerSQL Server MVP since 2007http://weblogs.sqlteam.com/tarad/ |
 |
|
|
|
|
|
Entity Framework