Zeeshan Hirani - All Comments

re: Entities with complex Type properties cannot be returned from Stored Procedure

mmknitin — Sat, 05 Nov 2011 15:18:20 GMT

How to assign this return type to a data table ??

re: Many To Many Mappings in Entity Framework

Mike Tirado — Sun, 30 Oct 2011 14:50:55 GMT

Excelent post. Was exactly what I was looking to answer. I am developing with the pattern Model-First and I generate the database from the model.

Thanks

re: Returning Random Products Using Linq To SQL

tlanders99 — Mon, 17 Oct 2011 05:11:21 GMT

I have found many examples like yours but I don't quite understand them...

what I don't understand is the first bit of code... create view, etc...

where does that first bit of code listed above go?? Probably a basic question but I have not found one post that explains it....

re: PageLoad event firing twice

Zeeshan Umar — Fri, 16 Sep 2011 06:58:24 GMT

Interesting finding, I always wonder why page_load is firing twice in some of my applications.

Thanks for sharing

re: Using ConfirmButtonExtender with ModalPopup Extender

cesardaniel78 — Sat, 20 Aug 2011 21:31:05 GMT

Hello,

Maybe you feel like helping me solve a mystery?

If so, check out the details here:

forums.asp.net/.../1

Thanks for any help. Have a good day.

re: Using Self Tracking Entity to retrieve and update

evgenybo99 — Mon, 08 Aug 2011 16:25:59 GMT

I built a small sample to show my issue exactly. If I execute two methods, the first one succeeds:

using (TestEF4M2M.TestEntities context = new TestEF4M2M.TestEntities())

{

Employee employee = context.Employees.SingleOrDefault(emp => emp.EmployeeID == 1);

employee.StartTracking();

employee.Projects.Add(context.Projects.SingleOrDefault(pr => pr.ProjectId == new Guid("08617439-3AA4-4271-AE6C-110846FB0F9A")));

employee.Projects.Add(context.Projects.SingleOrDefault(pr => pr.ProjectId == new Guid("9B90220E-E28E-472A-86DA-3FD12F863CFB")));

Project p1 = employee.Projects.SingleOrDefault(pr => pr.ProjectId == new Guid("08617439-3AA4-4271-AE6C-110846FB0F9A"));

employee.Projects.Remove(p1);

context.Employees.ApplyChanges(employee);

context.SaveChanges();

}

However when I execute the second method it fails:

using (TestEF4M2M.TestEntities context = new TestEF4M2M.TestEntities())

{

Employee employee = context.Employees.SingleOrDefault(emp => emp.EmployeeID == 1);

employee.StartTracking();

Project p1 = employee.Projects.SingleOrDefault(pr => pr.ProjectId == new Guid("9B90220E-E28E-472A-86DA-3FD12F863CFB"));

employee.Projects.Remove(p1);

employee.Projects.Add(context.Projects.SingleOrDefault(pr => pr.ProjectId == new Guid("08617439-3AA4-4271-AE6C-110846FB0F9A")));

employee.Projects.Add(context.Projects.SingleOrDefault(pr => pr.ProjectId == new Guid("9B90220E-E28E-472A-86DA-3FD12F863CFB")));

context.Employees.ApplyChanges(employee);

context.SaveChanges();

}

Thank you in advance for your help.

Evgeny.

re: Using Self Tracking Entity to retrieve and update

evgenybo99 — Mon, 08 Aug 2011 14:18:58 GMT

Hi Zeeshan,

I’m using EF4 STE for my WCF service and I’m having issue with Many- to-Many relationship. In my case user add select related entities from the list, and then remove. Then when I’m saving the changes I see the same entities in the ChangeTracker’s ObjectsAddedToCollectionProperties and ObjectsRemovedFromCollectionProperties. Then, when I’m calling ApplyChanges I’m getting the following error:

AcceptChanges cannot continue because the object's key values conflict with another object in the ObjectStateManager. Make sure that the key values are unique before calling AcceptChanges.

How can I solve this issue? Thank you in advance for your help.

Best regards,

Evgeny.

re: Many To Many Mappings in Entity Framework

lilk9 — Fri, 10 Jun 2011 19:05:43 GMT

How do you make a primary-foreign key, like in your ProjectAssigment table? I can only create a primary key or a foreign key

re: Changing Namespaces in Entity Framework

GBotros — Mon, 06 Jun 2011 14:23:47 GMT

Thanks

re: Filtering DataSet using linq

Kevin Grieger — Fri, 08 Apr 2011 19:51:34 GMT

Very nice! This is exactly what I wanted to see come out of a dataset!