I have a conceptual model in EDM where one of the entities has a property which is essentially a big value object whose properties aren't really useful as columns in the datamodel. I'd like to apply the Serialized LOB pattern to it so that I can fit it into a 192 byte binary column. How do I map this in the EDM v4? Is it even possible a...
The question is: Given a database backend that understands LeftStr and RightStr: where, in a custom ADO.NET provider implementation, would I establish a mapping to the immutable EDM canonical functions Left and Right? So I am working with the SQLite ADO.NET provider and it works, more or less, until you bump up against some string fun...
Yes, I need to clean a table and I have EDM that comes with .net 3.5 sp1 (I haven't tried with EF4). I know that works: foreach(var item in ctx.Elements){ ctx.DeleteObject(item); } but it's not a point to get all data from the table and and deleting one by one. Ok, I know it's deleted when I run ctx.SaveChanges(); but DELETE FROM [...
On EF4: e.g: I have a SystemRole entityType that has a SystemUsers navigation property, and SystemUser entityType has a SystemRoles navigation property, the association is from SystemRole.SystemRoleId to SystemUser.SystemUserId. My question is: Is there a way to get the "SystemRole.SystemRoleId" & "SystemUser.SystemUserId" from the sp...