Entity Framework for DBAs

MSDN Blog Postings » Entity Framework for DBAs

MSDN Blog Postings » Entity Framework for DBAs — Wed, 05 Sep 2007 06:04:33 GMT

PingBack from http://msdnrss.thecoderblogs.com/2007/09/04/entity-framework-for-dbas/

re: Entity Framework for DBAs

Andres Aguiar — Wed, 05 Sep 2007 17:42:42 GMT

Good start, but it will take muuuch more than that ;)

re: Entity Framework for DBAs

Erick Thompson — Thu, 06 Sep 2007 02:42:14 GMT

Andres,

I assume that you are from the DBA side of the house. What more would you like to see? What are your concerns?

Thanks,

Erick

Izindaba #8

From the software development trenches — Fri, 07 Sep 2007 08:42:40 GMT

Time for another weekly roundup of news that focuses on .NET and general development related content

re: Entity Framework for DBAs

triach — Fri, 07 Sep 2007 14:10:46 GMT

I like to concepts and thoughts about how this helps the DBA - but we all know when something like this comes up some will abuse this and ignore SP's and views etc and just use this. This will cause the DBA more heart ache unless as describe above it is used in a controlled manner and maintained within a give guideline of performance vs speed of development.

I will watch this very closely and have not made a decision either way - lets see what comes as it is release and I can actually see what affects it has.

re: Entity Framework for DBAs

Matt Neerincx — Fri, 07 Sep 2007 21:26:38 GMT

If I was a DBA, I would ask the following questions:

1. How can I control what entities are used against my server?

2. What prevents different development groups from using slightly different entity models? For example dev group 1 creates customer model that is different from dev group 2. The different models cause slightly different queries to occur on the back-end, and this increases the number of query plans on the server cache. Server is thus not used efficiently. I can control this with enforcing good development practices only? As a DBA I want to control this using access control on server side.

3. How can I as a DBA understand the entitie model and what sets of queries it will create? Are there any tools to analyze the entity model and determine what queries will be produced? As a DBA I don't understand entity language, I understand TSQL language, so if the tool could tell me what TSQL queries will be produced, then I could understand the implications of this an create indexes ahead of time to optimize the performance.

4. Does EDM have a way to dump it's showplan like SQL does? This way I can change my EDM code to produce a better plan (perhaps).

5. Does EDM have a analyzer that can tell me where I need to add indexes (like SQL's Index Tuning Wizard)? Or do I just need to write a bunch of EDM code, run my app with SQL Profiler running, then run Index Tuning Wizard on the result?

6. How can I optimize my EDM code to ensure I optimize my queries on the server side? With normal ADO.NET I can write the TSQL to use parameterized TSQL and ensure I have good cache hits.

So the main questions I can think of are about hitting optimum performance with SQL Server. DBA will want to know exactly what queries are produced and how to control what queries are produced (if possible). Random TSQL is worst case behavior, as it causes cache to blow out on server side. If there are ways to dump showplan for EDM this would help as well. If there is a way to convert EDM to TSQL this would help DBA understand impact as well.

LINQ to Entities

BonzBlog Michaela Juřka — Mon, 17 Sep 2007 22:07:34 GMT

Poslední reinkarnace LINQu, o které jsem se zmínil v přehledovém článku , je LINQ to ADO.NET Entities,

LINQ to Entities

BonzBlog Michaela Juřka — Mon, 17 Sep 2007 22:09:05 GMT

Poslední reinkarnace LINQu, o které jsem se zmínil v přehledovém článku , je LINQ to ADO.NET Entities,

re: Entity Framework for DBAs

Erick Thompson — Tue, 18 Sep 2007 23:42:03 GMT

Matt,

Those are some great questions. I'll be addressing these questions, and others, in the future. I'm going to be doing a webcast on this topic on Sept 27th, so please stop by with your questions.

Thanks,

Erick

Next-Generation Data Access

Cristian's Blog — Wed, 03 Oct 2007 11:08:41 GMT

SQL Server 2008 is at the door and the same stands for Visual Studio 2008. The data access strategy is

re: Entity Framework for DBAs

Rowland Gosling — Thu, 29 Nov 2007 20:04:11 GMT

I had an artist acquaintance who'd paint pictures of food. This looks an awful like his 'Hotdog in Search of Mustard' to me.

Maybe I've lost a few too many brain cells along the way but I don't see a benefit. I'm both a DBA and Devoper. I've seen a lot of code generators/techniques come and go. This might be a bit more flexible than ORM--or even useful to some extent. Or maybe not.

re: Entity Framework for DBAs

Siôn — Wed, 04 Jun 2008 17:21:56 GMT

Sounds great, but how do you access your Stored Procedures (Entity Functions) from code?

For example I have a trued and tested stored procedure that updates 5 tables and I would like to access it using the Entity Framework. Is this possible without having to write loads of custom code?