database agnostic - Page 795

Query to find tables modified in the last hour

- by oalo

I want to find out which tables have been modified in the last hour in a MySQL database. How can I do this? I am new to MySQL so please try to explain it as simply as you can. thank you!

working with decimal numbers in php

- by The Worst Shady

I want to somehow round the numbers for a rating system in php like this: 4.6667 = 4.6 5.0001 = 5.1 is there any way to do that? (BTW i read the datas from a database)

Retrieving/Updating Entity Framework POCO objects that already exist in the ObjectContext

I have a project using Entity Framework 4.0 with POCOs (data is stored in SQL DB, lazyloading is enabled) as follows: public class ParentObject { public int ID {get; set;} public virtual List<ChildObject> children {get; set;} } public class ChildObject { public int ID {get; set;} public int ChildRoleID {get; set;} public int ParentID {get; set;} public virtual ParentObject Parent {get; set;} public virtual ChildRoleObject ChildRole {get; set;} } public class ChildRoleObject { public int ID {get; set;} public string Name {get; set;} public virtual List<ChildObject> children {get; set;} } I want to create a new ChildObject, assign it a role, then add it to an existing ParentObject. Afterwards, I want to send the new ChildObject to the caller. The code below works fine until it tries to get the object back from the database. The newChildObjectInstance only has the ChildRoleID set and does not contain a reference to the actual ChildRole object. I try and pull the new instance back out of the database in order to populate the ChildRole property. Unfortunately, in this case, instead of creating a new instance of ChildObject and assigning it to retreivedChildObject, EF finds the existing ChildObject in the context and returns the in-memory instance, with a null ChildRole property. public ChildObject CreateNewChild(int id, int roleID) { SomeObjectContext myRepository = new SomeObjectContext(); ParentObject parentObjectInstance = myRepository.GetParentObject(id); ChildObject newChildObjectInstance = new ChildObject() { ParentObject = parentObjectInstance, ParentID = parentObjectInstance.ID, ChildRoleID = roleID }; parentObjectInstance.children.Add(newChildObjectInstance); myRepository.Save(); ChildObject retreivedChildObject = myRepository.GetChildObject(newChildObjectInstance.ID); string assignedRoleName = retreivedChildObject.ChildRole.Name; //Throws exception, ChildRole is null return retreivedChildObject; } I have tried setting MergeOptions to Overwrite, calling ObjectContext.Refresh() and ObjectContext.DetectChanges() to no avail... I suspect this is related to the proxy objects that EF injects when working with POCOs. Has anyone run into this issue before? If so, what was the solution?

Search Results

Search found 31293 results on 1252 pages for 'database agnostic'.

Page 795/1252 | < Previous Page | 791 792 793 794 795 796 797 798 799 800 801 802 | Next Page >

- by oalo

- by The Worst Shady

- by jslatts

- by danhere

- by user192972

- by Matthias Hryniszak

- by Hitesh Solanki

- by Jeff Storey

- by newbie

- by Mario

- by Nickson

- by Siva

- by robr

- by tecno

- by Phill Pafford

- by alexeyndru

- by every_answer_gets_a_point

- by Onion-Knight

- by Sandman

- by leonard

- by Cédric

- by Rosarch

- by Mitch

- by Jason

- by Jason

< Previous Page | 791 792 793 794 795 796 797 798 799 800 801 802 | Next Page >