Real World Software Architecture

Real World Software Architecture is dedicated to providing information and experiences from the field of Software Architecture.



Subscribe with RSS or ATOM Add to Google

Links

  • Home Page
  • Real World Software Process Engineering
  • Suggested Reading
  • .NET Dev and Arch Collection
  • SEI Essays on SA
  • Software Architecture
  • Bredemeyer
  • wwisa
  • Product Line Engineering
  • PLEES
  • Software Product Lines
  • MSDN Architecture Center
  • patterns & practices






Thursday, December 18, 2008

Entity Framework 1.0 Error Unable to update the EntitySet XXXXXX because it has a DefiningQuery and no DeleteFunction element exists

Unable to update the EntitySet XXXX because it has a DefiningQuery and no <DeleteFunction> element exists in the <ModificationFunctionMapping> element to support the current operation" is one of the errors you will eventually run into with the ADO.NET Entity Framework 1.0.

This error is caused by the resulting SSDL that is generated when mapping a table with no primary key.  Adding a primary key causes an error with the association mapping, so that isn't a good option.  I saw some posts on modifying the generated SSDL, but did not want to mess with that every time I had to update the model.  There are different approaches to addressing the problem.  I have listed some of the links I referred to below. 

I am posting this because I didn't follow any of them.  I added an ADO.NET connection to my data access layer and simply went around the association maps found in the generated EDMX. 

I can do this because I am doing a proof of concept that includes EF, which means I am simply testing is value as a tool.  Right now EF is failing as a production worthy tool.  They have a lot to fix in the next release. 

Blogs and forums on the issue:
EF - Generate with No Table Key
MSDN Forum Post
CRUD operations in Siverlight using ADO.NET Data Service
Ado.Net Entity Framework Many to Many Relationships
DefiningQuery Element (EntityContainer SSDL)

posted by tadanderson at 7:43 PM

0 Comments:

Post a Comment

<< Home

Previous Posts

  • Environmental Constraints, Business Requirements, ...
  • Pro Silverlight 2 in C# 2008 Book Review
  • Microsoft .NET Architecting Applications for the E...
  • Framework Design Guidelines (2nd Edition) Book Review
  • Will the Microsoft VSTS 2010 Architecture UML tool...
  • PDF Documentation Available for Composite Applicat...
  • Prism V2 Drop 1 (aka Composite Application Guidanc...
  • Advanced ASP.NET AJAX Server Controls For .NET Fra...
  • MS and patterns and practices News- Prism 2.0, App...
  • MS and patterns and practices News- Prism 2.0, App...



Powered by Blogger