C# Corner

Resources  
  • Assemblies : The Ins and Out : Part IApr 13, 2001. In Part 1, I will cover what exactly an assembly is, and what an assembly contains.
  • Assemblies : The Ins and Out : Part IIApr 16, 2001. In this part, I will discuss both Private and Shared assemblies and how to create a "Shared Assembly".
  • Assemblies : The Ins and Out : Part IIIApr 20, 2001. In this part I will discuss in more detail than Part 2, the available utilities for manipulating assemblies.
  • Transactions and Concurrency Control using ADO.NETAug 15, 2002. In this article I am concentrating on the transaction management and concurrency control in .NET environment.
  • Concurrency Control in ADO.NET using Threads and MonitorsDec 31, 2002. The concurrency controls system refers to the lowest level in architecture of a DBMS. It is relative to the input/output operations, which carry out the transfer of blocks from the secondary memory to the main memory and vice versa.
  • The "ins" and "outs" of Using Stored Procedures in C#Jan 27, 2003. This article reviews the creation of stored procedures with parameters using the Visual Studio IDE.
  • Basics of Extending Your Working Environment in Visual StudioApr 10, 2003. All of us have used Macros in Microsoft Office and Add-ins in Visual Studio 6 and I am very sure all of us have been impressed as well by their power to control their own working environment.
  • Building applications with DLinq DesignerJul 01, 2006. DLinq designer is the visual design surface to create the entity objects and bound the controls to the dlinq objects with relationships. We can easily create the windows form using the designer. The developer need not take more time to design the User Interface. The designer itself suggests you the controls suitable for the selected fields.
  • Using LINQ in Visual Studio 2005Jul 03, 2006. LINQ (.Net Language Integrated Query) is the general-purpose standard query operators that allow traversal, filter and projection operations to be expressed in a direct yet declarative way in any .Net programming language.
  • .NET Language Integrated Query for XMLJul 17, 2006. This is the overview of .NET Integrated Language Query for XML. This Article explains some of the features of XLINQ with example.
  • Assembly Viewer and Assembly Conflict Viewer in ASP.NETAug 10, 2006. This article show how to view assembly attributes and conflicts in ASP.NET page using C#.
  • Concurrency violation: the UpdateCommand affected 0 records. Mar 27, 2007. When you use a DataAdapter object to write changes back to a database by means of a stored procedure, you may receive the following error message: Additional information: Concurrency violation: the UpdateCommand affected 0 records.
  • Select Items with Where in LINQ and C#Jun 21, 2007. This article shows how to select exact match and in between items from a collection using LINQ and C#.
  • Reading and Writing XML using XLinqJun 21, 2007. XLinq is a new API to work with XML using LINQ. XLinq is more flexible, simple, and faster programming model to read, write, manipulate, and traverse XML documents.
  • Think in LINQ: Yahtzee Score Calculator Using LINQ TechnologyJul 23, 2007. This article revisits the yahtzee program I wrote in 2002 and reimplements scoring using LINQ technology. It compares the old way of scoring with LINQ and shows you the advantages of using LINQ.
  • Data Binding using LINQ to SQL in C#Aug 09, 2007. LINQ to SQL allows developers to work with databases using LINQ. This article discusses how to get, add, update, and delete data in a DataGridView control using LINQ to SQL.
  • Introduction to Building a Plug-In Architecture Using C#Sep 10, 2007. In this article we'll take another look at how we can use the state pattern to build a plug-in architecture that will allow us to change the behavior of our application by placing differnt plug-ins into a folder.
  • Chapter 1: Introducing ASP.NetJan 07, 2008. This article tells the features and frills of Asp.Net 3.5 and .Net framework.
  • Functional Programming in C#: CurryingJan 13, 2008. Currying is a way to re-write a function with multiple arguments in such a way as it can be called as a chain of functions each with a single argument. This article covers using a few simple utility methods you can use to curry your methods.
  • Functional Programming with C#: Lazy CalculationJan 20, 2008. I ran across Mike Gold’s nice algorithm for finding primes using LINQ syntax and thought I’d use his idea as a base from which to demonstrate one of the more subtle features in functional programming: lazy calculation.
  • Chapter 1: Hello LINQFeb 06, 2008. This is an exert from Joseph C. Rattz, Jr.'s book Pro LINQ. Here you learn how to use Linq in your application and also depicts the benefits of using Linq.
  • Using LINQ to Objects in C#May 26, 2008. This article provides an introduction to employing LINQ to Objects queries to support a simple win forms application; the article addresses the construction of LINQ to Objects statements and then goes on to describe how one might use LINQ to Objects within the context of an actual application.
  • Convert a LINQ Query Resultset to a DataTableJun 24, 2008. After a long struggle I find out the way to convert a Linq Query resultset to DataTable object. The attached source code shows how to do it.
  • Cascading Deletes in LINQ to SQLJul 03, 2008. This article will discuss alternative methods for performing cascading deletes using LINQ to SQL. Cascading delete refers to the action of removing records associated by a foreign key relationship to a record that is the target of a deletion action.
  • Generic Data Access using LINQ to SQL and C#Jul 22, 2008. This article discusses the construction of a generic data access layer built on top of a LINQ to SQL implementation.
  • SQL Server Stored procedures and UDF within LINQ context-PartIISep 03, 2008. In the first article, SQL Server Stored procedures and UDF within LINQ context-Part I, I exposed 2 scenarios of how to deal with stored procedures using LINQ, in this second part, I will accomplish the task by demonstrating how to call a user defined function UDF using the same way adopted in the first part.
  • SQL Server Stored procedures and UDF within a LINQ context-Part ISep 04, 2008. In this two parts particle, I will give techniques of how to deal with stored procedures and user defined functions UDF from within a LINQ context rather than ADO.Net.
  • Silverlight Tutorial: Creating a data centric Web Application with DataGrid, LINQ, and WCF Web ServiceSep 15, 2008. This step-by-step tutorial is a guide for creating a silverlight Web application capable of submitting and retreiving data from a database.
  • LinqDataSource Control in ASP.NET 3.5Sep 16, 2008. This article shows that how to use LindDataSource Control in ASP.NET 3.5.
  • Secrets of Extension Methods: Part IIDec 23, 2008. This article explains how Extension Methods are used in LINQ.
  • Using Data in Silverlight 2 Applications - IFeb 05, 2009. In this Article you will learn how to create a data connection, a LINQtoSQL class and a WCF service.
  • SQL Server Compact and LINQFeb 13, 2009. In this article, I will cover how to access data in SQL Server Compact databases (.sdf file) using new development technologies such as LINQ.
  • Easy LINQ to SQL Based Master-Detail Editor C#Feb 22, 2009. This article describes a simple approach to creating a LINQ to SQL based master-detail view with the ability to save changes made to the data. With practically no coding involved, the application below will allow the user to edit the master record as well as the detail records.
  • Introduction to Visual Studio Add-insMar 03, 2009. This article explains about Visual Studio 2008 Add-ins.
  • Introduction to Interfacing Win Forms with VS Add-insMar 04, 2009. This article explains about integration of Windows Forms with Visual Studio Add-ins.
  • LINQ FAQ for Newbie's Mar 05, 2009. In this article we will run through basics of LINQ and then see 5 basic LINQ queries which you will always need in your project for queries. While looking at the basics we will also try to learn what problem LINQ solves from the perspective of middle tier business objects.
  • Paging and Sorting ListViews with ASP.NET MVC and jQueryMar 23, 2009. This article provides a simple example of using jQuery along with the jQuery tablesorter and tablesorter.pager plug-ins to provide sorting and paging support for a listview within the context of an ASP.NET MVC application. JQuery has partnered with Microsoft and is now integrated within the IDE to include the availability of intellisense support.
  • SALT and PEPPER – 3 TIER and LINQMar 26, 2009. There is no pre-requisite (Oh yes even if you do not know LINQ this article will guide you) for this article J what I need from you guys is time to read this article. So block your 10 minutes and rest assured you will understand LINQ in a much better way.
  • Implementing optimistic concurrency control in ASP.NET 2.0May 05, 2009. This article is intended to illustrate how to implement optimistic concurrency control in ASP.NET. Optimistic concurrency control is a mechanism to check when multiple users concurrently access and change a common data item; they don’t overwrite one another’s change. I’m going to illustrate a common scenario in an enterprise application and to show how we can solve the concurrency problems using optimistic concurrency control and the underlying implementation using Microsoft technologies.
  • Search and selection of data using LINQMay 27, 2009. In this article I will explain how you can use LINQ, when we should search and select some data according to parameters, defined by users.
  • An Introduction to LINQJun 06, 2009. LINQ stands for Language INtegrated Query. Means query language integrated with Microsoft .NET supporting languages i.e. C#.NET, VB.NET, J#.NET etc. Need not to write\ use explicit Data Access Layer.
  • Parallel Extension to LINQ Jun 18, 2009. This article gives you an idea how to utilize Parallel Extension to Linq or PLINQ.
  • One-Many and One-One relationship using LINQ to SQLJul 03, 2009. In this article we will start with a basic LINQ to SQL example and then see how we can implement one-many and one-one relationship using ‘Entityref’ and ‘EntitySet’. We have also attached a source which demonstrates the same in a practical manner.
  • Simple 6 steps to use stored procedure in LINQJul 08, 2009. This is an extremely small article which describes how to flourish LINQ objects using stored procedure. What provoked me to write this article is the ‘ExecuteMethodCall’ function which helps to execute stored procedures in LINQ. As this is a protected function it changes the way you architect the DAL using ‘DataContext’ class and probably you would like to tweak and consider some options here. You can see more details of it when you read through the steps below. I am writing a huge series of LINQ FAQ and these small articles form small sprints to complete the huge FAQ series. I hope you enjoy it.
  • CRUD operations using LINQ EntitiesJul 12, 2009. This is a pretty simple tutorial dedicated to LINQ newbie’s who want to learn how to do CRUD operations using LINQ entities. I am sure many experienced LINQ players would criticize me for such a mild article.
  • LINQ FAQ for Newbie's Jul 13, 2009. In this section we will run through basics of LINQ and then see 5 basic LINQ queries which you will always need in your project for queries. While looking at the basics we will also try to learn what problem LINQ solves from the perspective of middle tier business objects.
  • LINQ FAQ Part 2Jul 14, 2009. This FAQ article is dedicated to LINQ to SQL. In this article we will see a basic example of LINQ to SQL, how to define 1-1 and 1-many relationship using LINQ, how we can optimize LINQ queries, execution of stored procedures using LINQ and finally we will see a simple CRUD example using LINQ to SQL. For past some days I was running small sprint to complete this marathon I hope you will like this article.
  • How to improve your LINQ query performance by 5 X times ?Jul 17, 2009. LINQ has been criticized by many early adopters for its performance issues. Well if you are just going to drag and drop using DBML code generator I am sure you will land up in to mess. Try doing this make a simple LINQ to SQL project using DBML and see your SQL profiler, I am sure you will never like to touch DBML code generator again. In this article we will first look in to how LINQ queries are executed, and then we will touch base on how compiled LINQ queries can help us improve our application performance at least 5 times. My numbers can be 10% up and down as I had come to that figure using my environmental situations.
  • How to handle concurrency in LINQ to SQLJul 20, 2009. In this article we will touch base some important concepts of handling concurrency in LINQ to SQL.
  • XML Diff and Patch using LINQ to Xml and LINQ to ObjectsJul 26, 2009. This article focuses on working with XML and how to get best out of LINQ to XML and LINQ to Objects. Focus of this article is to you show the power of LINQ to Xml and get you started on LINQ with practical examples.
  • Migration strategy for simple .NET classes to LINQ classesJul 27, 2009. This article will focus on how we can convert simple existing .NET classes in to LINQ enabled classes.
  • Introduction To linqJul 29, 2009. This article is a basic introduction to LINQ.
  • Using partial class, when working with LINQ to SQL Stored ProceduresJul 30, 2009. In this article I will explain how you can combine using of your own classes to DataContext (dbml file) and partial DataContext class, when working with LINQ to SQL Stored Procedure.
  • Creating and Saving XML Tree Using LINQ to XMLJul 30, 2009. This article explains how to create a XML Tree using LINQ. This will explain the Functional Construction way to create a XML tree.
  • LINQ FAQ Part3Aug 01, 2009. This is the third series in my LINQ FAQ series. In this series we will cover LINQ FAQ’s related to concurrency handling, compiled queries, CRUD implementation and mapping simple .NET classes with XML file configuration. I love to write articles in FAQ format for the only purpose that they are to the point and you can get to know more by reading less.
  • How to create 3 tier application using LINQAug 03, 2009. This article describes how to create 3 tire architecture project in LINQ to SQL.
  • Gridview paging and multiple row delete using checkboxAug 14, 2009. This article describes how to bind GridView using LINQ, dynamic paging and how to delete multiple rows using checkbox selection.
  • LINQ Deferred ExecutionAug 24, 2009. In this article we will see how LINQ defers the execution of the query till you request the results. Plus, learn how to execute the query immediately.
  • Best Practice No 4:- Improve bandwidth performance of ASP.NET sites using IIS compressionSep 16, 2009. Bandwidth performance is one of the critical requirements for every website. In today's time major cost of the website is not hard disk space but its bandwidth. So transferring maximum amount of data over the available bandwidth becomes very critical. In this article we will see how we can use IIS compression to increase bandwidth performance.
  • ASP.NET MVC Web Application Using LINQ to SQL ClassesOct 11, 2009. This article will demonstrate how to use an ASP.NET MVC Web Application using LINQ to SQL Classes.
  • Introduction to LINQ, Extension methods and Lambda ExpressionsOct 18, 2009. This article is an introduction of LINQ, Extension methods and Lambda Expressions. In my following articles, I will delve into more details.
  • Show/Delete/Edit data in WPF DataGrid using LINQ to SQL ClassesOct 29, 2009. This article will demonstrates how to Show, Delete, and Edit data in WPF Data Grid using LINQ to SQL Data Classes.
  • Using PLINQ to Improve Learning AlgorithmsNov 30, 2009. PLINQ is a welcome addition to the .NET 4.0 framework, allowing us to operate on collection elements in parallel. This article examines the performance improvements of PLINQ over LINQ when doing heavy calculations on a large collection of genomes in a particular learning algorithm.
  • GridView using LINQ and Convert datetime to shortdate in LINQ.Dec 30, 2009. In this article you will learn how to create a hyperlink in GridView using LINQ and Convert datetime to shortdate in LINQ.
  • Applications using Linq to SQLJan 10, 2010. In this article, I want to illustrate the principles, techniques and tools to develop applications using Linq to SQL after a deep research on this topic.
  • Transactions and Concurrency in ADO.NETJan 18, 2010. In this article I will explain about Transactions and Concurrency in ADO.NET.
  • Binding using LinqDataSource controlJan 31, 2010. In this article, I will explain how to implement data binding techniques in Web applications using Language Integrated Query (Linq) and LinqDataSource control shipped with ASP.NET 3.5.
  • LINQ to SQL in Silverlight 3Feb 16, 2010. In this article we would see how can we use Linq to Sql ORM in Silverlight 3 Application for interactinig with SQL Server Database.
  • Using LINQ, when working with images in Web ApplicationFeb 21, 2010. In this article I will explain how you can use LINQ, when working with images in Web Application
  • LINQ to XML Part 1 - XAttribute ClassFeb 21, 2010. In this article, I will give explanation on XAttribute class. This class is used to construct Attributes in XML Elements.
  • LINQ to XML Part 3: Functional Construction of XML TreeFeb 22, 2010. This article will give an explanation on how to create a XML tree using Functional Construction method of LINQ to XML.
  • LINQ to XML Part 4: Different way of Parsing string to create XML tree Feb 22, 2010. In this article, I will show different way of parsing string to create XML tree using LINQ to XML.
  • LINQ to XML Part 5: Catching Parsing ExceptionsFeb 22, 2010. This is a very high level article which will explain how to handle exception in parsing XML using LINQ to XML.
  • LINQ to XML Part 2: (XElement Class)Feb 23, 2010. In this article I describe the XElement class. This class is used to construct XML Elements.
  • LINQ to XML in Silverlight 3.0Feb 23, 2010. This article will explain how to use LINQ to XML to read data from a XML file and bind that to Silverlight 3.0 DataGrid.
  • LINQ to Object Part #2: Filtering and SortingMar 04, 2010. In this article, I am going to show you how we can achieve filtering and sorting using LINQ to object.
  • LINQ to Object Part #1: ProjectionMar 06, 2010. In this article, I am going to show, how we could achieve projection in LINQ to object.
  • LINQ to Object Part #3: GroupingMar 08, 2010. In this article, I am going to show, how we could achieve grouping in LINQ to object.
  • LINQ to Object Part #4: Querying Non- IEnumerable collectionsMar 15, 2010. In this article, I am going to show, how we could apply LINQ to query non-IEnumerable<T> Collections.
  • LINQ to SQL Performance ConsiderationsApr 01, 2010. This article focuses on some of the performance issues while working with LINQ to SQL.
  • Accessing Array and Collection using LINQApr 05, 2010. This article will teach you about how you can Access Array elements and Collections using LINQ.
  • LINQ to SQL, LINQ to XML and Accessing DataTable using LINQApr 20, 2010. This article demonstrates how to use LINQ on DataTable, XML Data using LINQ to XML and SQL server data base using LINQ to SQL Classes.
  • Silverlight 4 Linq to Sql and RIA sevice for CRUD operationsApr 26, 2010. Silverloght 4 has lots of new fearures, for details visit Silverlight 4 . Let's start with a small application to perform CRUD operations using Linq to SQL and RIA Services.
  • Linq to SQL Performance Considerations: Part IIApr 29, 2010. This article takes a look at what it takes to convert Linq queries to compiled queries and what performance gains can be obtained.
  • Using LINQ to SQL QueryMay 04, 2010. Here in this article, you will get very basic idea of LINQ to SQL Query using code.
  • Using LINQ to SQL ClassMay 07, 2010. In this article, I am going to show you how we can perform various operations using LINQ to SQL.
  • Javascript and Linq MenusMay 10, 2010. In this article you will learn how to use Javascript and Linq Menus in C#.
  • Image Manipulation using LINQ to SQL from ASP.Net ApplicationMay 11, 2010. In this article, I am going to show you How to insert an image from ASP.Net application to SQL Server using LINQ to SQL and how to retrieve image from SQL Server data base using LINQ to SQL and display to an Image control.
  • Validation in Linq to SQL and ASP.NETMay 19, 2010. In this article, I will show how to add business rules to Linq to SQL data model default set of schemas.
  • Writing Equivalent LINQ Expressions in F#Jun 07, 2010. In this article we will compare LINQ expressions to the equivalent F# expressions for an F# List and show how to use projection, filtering, and other LINQ goodies in F#.
  • WCF Concurrency (Single, Multiple and Reentrant) and ThrottlingJun 27, 2010. In this article we will concentrate on WCF concurrency and throttling. We will first try to understand what are WCF concurrency and the 3 important types of WCF concurrency. We will then see a small sample of WCF concurrency with single and multiple. We will then go through 9 combinations of WCF concurrency and instancing. Finally we will try to understand how to configure throttling using WCF ‘web.config’ file.
  • Creating a Windows Phone 7 Application Consuming Data Using a WCF ServiceJul 01, 2010. The objective of this article is to create a WCF service that retrieves data from the database using LINQ to SQL classes and a Windows Phone 7 application that consumes that service to display the data.
  • LINQ to SQL in C#Jul 24, 2010. This article provides an introduction to employing LINQ to SQL within a Windows Forms application; the article will address the incorporation of LINQ to SQL into a win forms project, how to use LINQ to SQL to select, insert, update, and delete data, and how to use LINQ to SQL to execute stored procedures.
  • Creating a Silverlight Application that inserts data to a database using WCF serviceAug 02, 2010. In this article, I have created a Silverlight application that asks users to enter choices & moves to specific pages depending on the choices. I have shown here how to use merged resource dictionaries. We can also see how to create controls dynamically. Finally, this application consumes a WCF service to store data in the database using LINQ to SQL.
  • LINQ with IIS sites and web Applications Aug 09, 2010. In this article, we will see how to work with LINQ against IIS.
  • Select and SelectMany: LINQ projection operatorAug 16, 2010. Projection transforms the query result into the form defined by the developer. There are two projection operators in LINQ
  • Parallel Computing – Visual Studio 2010 - .NET 4.0 Aug 25, 2010. Microsoft's Visual Studio 2010 & .NET Framework 4 provided a way to achieve this by using the Parallel Library and Parallel LINQ in it.
  • Remove Duplicate Items From Generic CollectionSep 06, 2010. In this article Remove Duplicate Items From Generic Collection
  • LINQ Operators and Lambda Expression - Syntax & ExamplesSep 08, 2010. LINQ is a cool feature in C# 3.0. Most of the developers are struggling for the syntax and examples. Here I have collected various examples for each operator in LINQ and the equivalent Lambda Expressions.
  • 6 Ways of Doing Locking in .NET (Pessimistic and Optimistic)Sep 28, 2010. This article talks about 6 ways of doing locking in .NET. It starts with concurrency problems and then discusses about 3 ways of doing optimistic locking.

About Concurrency-conflicts-in-LINQ

NA
File APIs for .NET
Aspose are the market leader of .NET APIs for file business formats – natively work with DOCX, XLSX, PPT, PDF, MSG, MPP, images formats and many more!
Download Free eBooks