Sequence contains no elements : LINQ error

If you are using LINQ or Lambda expression and getting error: InvalidOperationException “Sequence contains no elements”. It means you are trying to retrieve an element from an empty sequence(may be returned by LINQ query). There are some basic rules to handle this in LINQ or lambda expression.

New Features in BrijPad 1.1

Approx one month ago, I launched BrijPad – An Online Fast Development Tool. First, I thank you all for giving feedback. I have received lots and it is wonderful of you to take the time to read and comment. I got some expected points and some new points to make it attractive. Being a weekly blogger, I can’t go fast, but have added some required functionality and new features. This post explains the new features and functionality.

Concurrency violation: the UpdateCommand affected 0 of the expected 1 records

I was updating database using DataAdapter.Update method and got following error:

System.Data.DBConcurrencyException: Concurrency violation: the UpdateCommand affected 0 of the expected 1 records.

I was updating 2-3 columns of tables (having 20 columns) and expected to update those columns only. I fixed the problem and decided to write on it.