LINQ

Thanks! That's a good pointer. I have also since found an evaluator library (in C#) that parses Excel style formulae, On which I can modify range specs to instead use collection variables.

Thanks for your reply. It will take me a little to digest. I see what you are saying about overridding the GetHashCode. Could I achieve the same thing by overridding the ToString() method? The reason for only the one comparison in the LINQ is that I could not get the select to output two fields. I tried just selecting the objects by that did not work (because of the GetHashCode??) I shall have more of a play. Cheers. The FoZ

Try our Oracle-specific LINQ to SQL implementation. Short overview is available here. Devart Team http://www.devart.com/dotconnect ADO.NET data providers for Oracle, MySQL, PostgreSQL, SQLite with Entity Framework and LINQ to SQL support

MSDN is your friend

Yes, it's useful.

Thank you

Hi Daniel, Thanks, will give this a try ____________________________________________________________ Be brave little warrior, be VERY brave

If there is primarykey-foreign key relation in tables u hv to insert primarykey tables first after that u can insert in foreign key tables means in child tables. Thanks and Regards Sujit Kr. Mandal

remove & add it again. Thanks and Regards Sujit Kr. Mandal

Nice. Gotta love the smell of baking bread, pretty great. Daniel Vaughan Blog: DanielVaughan.Orpius.com Company: Outcoder

The problem looks like it's associated with recursive usage of the same DataContext instance during the SubmitChanges() execution in your code. Try to create a new context instance each time you need to save a log. Devart Team http://www.devart.com/dotconnect ADO.NET data providers for Oracle, MySQL, PostgreSQL, SQLite with Entity Framework and LINQ to SQL support

J4amieC wrote: What a surprise, our OP just doesnt bother to respond to 2 serious answers. Patience brother! ;)

Thanks. I saw the one entity model template but avoided it since it was called ADO.NET. ;) So I'm sure in code my consumption of it will be somewhat different but I'm very comfortable with Linq to SQL. Thanks for explaining the differences.

Wouldn't the statement be OR? Does he want and? Unless that is what he wants I apologize :)

...but you can use stored procedures with Linq to SQL! Just drop the SPROCS onto the entity surface and in your linq code you execute the sproc like a method. So your statement about SPROCS is incorrect.

Sanket.Patil wrote: Thanks for your reply. But if you could send me your reply again i will be glad to recieve. I don't understand what you mean here, could you rephrase the question? I also don't understand why you deleted your original message, as that means nobody can now review the questions and answers in order to make suggestions.

J4amieC wrote: Can I see a sample of your xml, im sure this one should be easy enough. Nope, it's 6pm and I'm sitting here (at home) with a nice glass of white and that bloody thing has been left in the office. VS grumbled until I put the .Equals on the end. The only relevant thing should be that the NodeKey is a SQLHierarchyID I would think. I eventually chucked linq and went back to a stored proc to do the job - I'm seriously not happy with linq as it continually dissapoints. Never underestimate the power of human stupidity RAH