C# Corner

Resources  
  • Late Binding With ReflectionOct 20, 2003. Component based technology has done great things for software development, allowing reuse and leading to better-written code that separates subjects and entities into distinct components.
  • 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.
  • 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.
  • 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.
  • How to Generate an XML Document Programmatically-Using System.Xml.XmlWriter: Part IIIJun 26, 2008. In previous articles, I demonstrate how to generate a given xml file using both the DOM “Document Object Model” and the SAX “Serial Access parser for Xml” technologies. In fact, they are very interesting API for handling xml entities or files but the dot net provides us another way to achieve the same goal.
  • 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.
  • Silverlight 2 use ADO.NET Data Services to access dataJul 19, 2008. In this article will show how to perform CRUD (Create, Retrieve, Update, Delete) operations in Silverlight 2 using ADO.NET Data Services.
  • 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.
  • Getting started with ADO.NET Entity Framework in .NET 3.5Sep 30, 2008. This article contains a very simple ADO.NET Entity Framework application to display and add the data to the database using ADO Entity Framework.
  • Getting started with ADO.NET Entity Framework in .NET 3.5 - Part IIOct 06, 2008. This article contains a very simple ADO.NET Entity Framework application to update and delete the data to the database using ADO Entity Framework.
  • Getting started with ADO.NET Entity Framework in .NET 3.5 - Part IIIOct 13, 2008. This article show us how to do conditional query and paging in ADO.NET Entity Framework.
  • Distributed Database Management SystemsDec 17, 2008. I’m going to illustrate the principles of Distributed Database Management Systems through this article.
  • Secrets of Extension Methods: Part IIDec 23, 2008. This article explains how Extension Methods are used in LINQ.
  • Customizing GridView Control For Data ModificationsJan 28, 2009. This article is intended to illustrate how to customize GridView controls for data modification.
  • 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.
  • BizTalk OrchestrationsFeb 06, 2009. In this article, I will cover one important component of Microsoft BizTalk Server, the orchestrations. Basically an orchestration is the executable code to run a workflow supporting a business process. Orchestration interacts with outside entities by using the ports. All these things together are a powerful tool to perform process automation.
  • 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.
  • Introduction to Dynamic Data Web Application Model: Part VIFeb 18, 2009. This article explains about interfacing Stored Procedures and Dynamic Data Entities Web Application template.
  • 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.
  • 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.
  • 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.
  • Setting Null Value in an Optional Non-identifying Relationship Using ComboxBoxMay 06, 2009. The most common relationship in any data model is the one-to-many non-identifying relationship. Non-identifying relationship implies weak dependency relationship between parent and child entities. There are two kinds of non-identifying relationships, including optional and mandatory. The necessity of the parent entity is "exactly one" and "zero or one" in the mandatory and optional non-identifying relationship respectively. One problem I’ve tackled in many of my enterprise application is the presentation of complex data relationship such as optional non-identifying relationship using data binding techniques in Windows Forms applications. In this article, I will illustrate how to face this problem.
  • Setting Null Value to an Entity Property Through Textbox ControlMay 12, 2009. In this article, I want to document a bug in Visual Studio. NET concerning to setting a null value to entity property’s through a Textbox control. There is a common scenario to have an entity type in your data model where some attributes are optional. When you develop a rich client application using the Windows forms, data binding techniques and a Textbox to enter the simple data, and you want to set null the optional attributes of the underlying data source by leaving in blank the Text property of the Textbox control; then there is a missing feature for the Formatting and Advanced Binding dialog box for null values. They should have a checkbox there to allow people to use blank as null. In this article, I will show one simple solution to this bug.
  • Implementing business rules using customized DataSet objectsMay 15, 2009. Information systems contain and enforce rules about the business they support. A rule is constraint which describes the way how objects are to behave. Field-level validations are checks that pertain to the property values of the underlying business entities. For example, a field must be 50 characters or less in length or some fields are required while other fields are optional as well as some fields must be greater than a specific value.
  • 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.
  • MVC Declarative BindingJun 08, 2009. One of the things that makes the bar to implement any “MVC-ish” pattern high is the tremendous amount of plumbing required just to get started in order for the different entities to communicate state changes. This article introduces a utility library that can be used to declaratively bind the model and view encapsulating all the wiring required and making implementation much easier.
  • 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.
  • Using WCF with ADO.Net Entity Model to Expose CRUD Operation as a SOAP Enabled ServiceJul 19, 2009. I have seen on web many people talking about, how to deal with DTO classes and business class in WCF. And those entire topics persuaded me to write this article.
  • 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.
  • 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.
  • 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.
  • 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.
  • Building ASP.NET MVC Web Applications using ADO.NET Entity Data ModelOct 09, 2009. This is a step by step tutorial on how to build ASP.NET MVC Web Applications using ADO.NET Entity Data Model and Visual Studio.
  • 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 ADO.NET Entity Data Model in WPFNov 06, 2009. This article will show you how to fetch and show data from database using ADO.NET Entity Data Model in WPF.
  • An XML Document and its ItemsNov 19, 2009. In this article I will explain you about XML Document and its Items.
  • Standardizing Incoming Messages Using Inbound Maps Tab on Receive Port Properties in BizTalk ServerNov 25, 2009. In this article we will see how to develop integration applications which receive documents with different schemas arriving from external entities, and it’s required to transform each format to a common (canonical) internal schema using port maps on the receive ports in BizTalk Server.
  • 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.
  • 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.
  • ADO.NET Data Model and ADO.NET Data Service in Silverlight 3Feb 17, 2010. In this article we would see how we can use ADO.NET Entity Data Model as the ORM in Silverlight 3 Application, and ADO.NET Data Service to fetch the data.
  • 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.
  • 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 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.
  • Start with EntitySQL and Entity FrameworkMar 22, 2010. This article meant for aspirants need a start towards Entity Framework.
  • 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.
  • RIA Services with Silverlight 4: Part IMay 03, 2010. This article will show you how to use Domain Service Class using Silverlight business application with ADO.NET Entity Data Model.
  • 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.
  • RIA Services - using Entity FrameworkMay 21, 2010. In this article I will walk through step by step to demonstrate how Entity Framework can be used to access SQL database.
  • Silverlight RIA Service using ADO.NET Entity Data Model: Part IIJun 03, 2010. This article demonstrates how to use RIA services with ADO.NET Entity Data Model and how to use page navigation in Silverlight.
  • 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#.
  • Working with Entity Data Model and Executing Stored ProceduresJun 21, 2010. In this article we are going to work with the following concepts that EDM support.

About linq-to-entities

NA

SPONSORED BY

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!
Visual Studio Live - Redmond 2016