Check if objects exist

[sitefinitysteve]

Whats the best way to check if an object already exists in the database?  If a user refreshes my form it tries to re-insert the same object back into my table and I get an exception...

Is there a best practice for that?

[Alexander]

Hello Steve,

I am afraid you will have to execute a query to determine if an object with particular ID already exists. You can use the FirstOrDefault() method:

Customer c = scope.Extent<Customer>().FirstOrDefault(x => x.CustomerID == "ALFKI");

The method returns null if the object is not found. Hope that helps.

Greetings,
Alexander
the Telerik team

Instantly find answers to your questions on the new Telerik Support Portal.
Watch a video on how to optimize your support resource searches and check out more tips on the blogs.

[sitefinitysteve]

Can you check based on an entire object as well?...so not just the ID col, but like an object.Equals()?

[Alexander]

Hello Steve,

Once you have retrieved the object with the query mentioned in the previous post you can compare it manually to the other object property by property or by implementing a Comparer class that can do this for you.

Kind regards,
Alexander
the Telerik team

Instantly find answers to your questions on the new Telerik Support Portal.
Watch a video on how to optimize your support resource searches and check out more tips on the blogs.

[sitefinitysteve]

Darn, okay thanks :)

Can you put in a feature request for some sort of IfExists(object) support?

[Jordan]

Hi Steve,

Sure, we will add this feature to our TODO list.
Unfortunately I cannot give you an exact time frame for when it will be implemented at the moment.

Greetings,
Jordan
the Telerik team

Instantly find answers to your questions on the new Telerik Support Portal.
Watch a video on how to optimize your support resource searches and check out more tips on the blogs.