LINQ Error

[Bharat89]

Hello folks,

Posting a new query about the LINQ. I am using SQL EXPRESS for my database and i have created a datatable in it. But the problem is that i am unable to run the LINQ code onto it. The datatable code is generated automatically. Whenever i am running the command it prompt me error about the definition of SingleOrDefault and no extension for the same. Now you help me because i have already tried hard but not succeeded

Thanks in advance.

[Devasis]

Hi,

First let me know that from where you are getting generated code. Is it some where form the Linq to SQL classes or is it from the Link to Entities classes.If its not coming from any of the above then you can move to the client side query to Array() as result. Try to use linq to object. Try this out it will work with the LINQ error and your database will start working properly.

Say thanks if you liked the idea because a thanks may be appreciated.

Bye...........

[kelfro]

A well-designed set of error handling code blocks can make a program more robust and less prone to crashing because the application handles such errors. Know when to set up a try/catch block. For example, you can programmatically check for a condition that is likely to occur without using exception handling. In other situations, using exception handling to catch an error condition is appropriate. The following example uses an if statement to check whether a connection is closed. You can use this method instead of throwing an exception if the connection is not closed.

To know more about the exception handling click here

[Zecho]

Hi,

Here i am discussing about the throwing exception from the component. Visual Basic .NET also supports unstructured error handling using the On Error Goto syntax. While this kind of error handling will continue to function in your components, it is not recommended that it be implemented. Code written using this method of error handling is difficult to debug and maintain, and it can degrade application performance. Structured error handling, using the Try...Catch...Finally block, results in code that is easier to maintain, more robust, and more flexible in the way that errors can be handled.

Detailed information about the same is here

[Modifier]

As per my knowledge, Which i gained from the MSDN. LINQ is a set of extensions to the .NET Framework that encompass language-integrated query, set, and transform operations. It extends C# and Visual Basic with native language syntax for queries and provides class libraries to take advantage of these capabilities.

Thank you