Cool – two in one day!
Another goody on the ADO.NET Entity Framework & LINQ to Relational Data Code Gallery page …
Entity Framework Extensions Library. I’ll subtitle this as “stuff we couldn’t get into v1, but know you need”!
The first one today was a tool to help you visualize what different types of mapping in an EDM do and what their schema looks like – EF Mapping Helper.
from KIDSvt.com
Are you an ASP.NET / SQL Server Developer? Are you looking for more clients?
In need of a freelance ASP.NET / Sql Server Developer to take over the web application needs of a small business. We have an EXTREMELY urgent need to extract data from a sql server 2005 database into a “pretty” format in MS Word. We’re willing to purchase the Aspose.Words ( www.aspose.com )software (or any other reasonably priced reporting software tool) to complete the project. The Aspose.Words software allows you to generate a MS Word document from data in a sql server database, through your ASP.NET application, without having to use MS Word itself.
Beyond this project, we’de like to build a relationship with a local .NET developer so we have a “go to” person to support our future web application needs.
If you’re interested, please contact Susan Holson at 802-985-5482 as soon as possible.
There’s a new very cool tool on MSDN Code Gallery from the EF Team called EF Mapping Helper.
What it does is allow you to select various mapping scenarios (eg. TPH Inheritance) and the helper will display a visual image of what the mapping does and the actual XML of the CSDL, SSDL and MSL so you can see what it looks like in the actual schema.
You can combine the mapping types to see how they all look together as well.
This is a huge benefit because sometimes it’s just hard to set these things up, therefore how can you see the impact. It’s a really great way to look at this – if you are not afraid to look at XML. 🙂 (Since the visual designer can’t do everything, it’s useful (to say the least) to know how to work in the XML.)
It will also give ideas of some of the cool things you can do with mapping in an EDM that you may not have thought about. EDM’s highest power is in it’s ability to really shape your conceptual layer in ways that you can’t do with traditional ORMs. But learning all of the different ways to customize a model can be daunting. So I’m really happy to see this tool!
Here’s a view of a TPH mapping (click on image for full size)
and a view of a model that contains a TPH and TPC (table per concrete type). It’s quite dizzying, so I’d recommend looking at individual mapping scenarios first.
