C# Corner

Resources  
  • 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.
  • 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.
  • 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.
  • 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.
  • 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.
  • 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.
  • 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#.
  • 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.
  • Working with LINQ in SharePoint 2010Oct 05, 2010. In this article I am showing how to use LINQ in SharePoint 2010 web part. SharePoint 2010 has the ability to use LINQ syntax to fetch data from lists instead of using the CAML queries.
  • Finding Odd numbers using LINQ in C#Oct 05, 2010. In this article we will see how to find odd numbers from a range of number using LINQ in C#.
  • Horoscope Program for Windows Phone 7Nov 03, 2010. This article show how to create a Horoscope Application for Windows Phone 7. The tecnologies used are XAML, WCF, LINQ and C#.
  • LINQ to SharePoint: SPLinq in SharePoint 2010Nov 09, 2010. In this article, we will see how to work with LINQ to SharePoint. I have tried to address all the common errors we encounter when first time we start using LINQ against SharePoint.
  • Sorting in Repeater Control in a simple way using LinqNov 12, 2010. This tutorial will explain how to implement sorting in repeater control using Linq and this is a simple way of sorting within the repeater control.
  • Sorting in DropDown List in a simple way using LinqNov 12, 2010. In this post I am going to tell how you can sort the dropdown list based on DataTextField and DataValueField using Linq.
  • Walkthrough on using LINQ to SharePoint from within a SharePoint 2010 custom visual web partNov 20, 2010. In this article we will see, how to create custom WebPart, how to use SPGridView on visual WebPart, how to use LINQ to SharePoint, how to deploy the WebPart in SharePoint site.
  • Reading XML Attributes using LINQ to XML in Silverlight Nov 29, 2010. This code snippet demonstrates how to load an XML file and reads its nodes and their attributes in a Silverlight application using LINQ to XML.
  • Insert/Update/Delete in DataGridView using Linq in Windows FormsDec 02, 2010. This article will explain how to insert, update, delete records in DataGridView using Linq.
  • Linq queries for beginnersDec 02, 2010. Following are some of the basic Linq command/samples for those who just want to start learning Linq.
  • How to Diagnose System Usage with a LINQ QueryDec 20, 2010. This LINQ query determines the top 5 applications that are using the most memory in the system.
  • WCF Data Service with LINQ to SQL ClassDec 23, 2010. In this article we are going to see how to use WCF Data Service with LINQ to SQL Class.
  • Get All the Tables Name using LINQDec 28, 2010. In this article you will learn how to get the names of all the tables using LINQ
  • Listing columns name with type of a table using LINQDec 29, 2010. After my last article, I got a question asking how to list all the Column names of a given table using LINQ.
  • Var versus IEnumerable in LINQDec 29, 2010. In the example below, we are querying a collection of string so we know the output will be a collection of strings, so we are using here IEnumerable with string.
  • Deferred Execution and Immediate Execution in LINQDec 31, 2010. Deferred Execution executes a query only when a loop starts. What I mean here is that, we iterate through the query variable to get the result.
  • Using Stored Procedure in LINQJan 04, 2011. We have a strored procedure as below. It is a very simple SP returning grades of the student. This stored procedure name is GetStudentGrade .

About Where-LINQ

NA

SPONSORED BY

Custom Software Development
MCN is your source for developing solutions involving websites, mobile apps, cloud-computing, databases, BI, back-end services and processes and client-server applications.
European SharePoint Conference