The following is far easier to understand and use than the Outlaw's tip (IMHO).text = Regex.Replace(text, "screen_fadetimeout=\"[^\"\']+\"", "screen_fatetimeout="99");It has the following advantages:1. It is one line of code2. It is easier to read3. It is faster (note: XmlElement...

.NET Important Topics Summary - Code Examples

by Yaseer Mumtaz

.NET interview questions and answers with real world examples and code snippets

15.2 What's New for XAF

by Michael Bogaerts

What brings the 15.2 release for XAF (win) developers

A better way to count(*)

by Lee Humphries

LINQ translates .count() to a SQL query that uses COUNT(*), but on large tables even count(*) can be too slow. Here's another way

A better way to count(*)

by basementman

Or, assuming your table has an index, you could do this "old-school" as:select MAX(rows) from sysindexes where id = Object_ID('{tablename}')

A Generic ADO.NET Overlay to Simplify DB Calls to SQL Server and Oracle

by shijo joseph

An ADO.NET Layer for SQL Server and Oracle which makes it easier for interfacing with database

A Pagination Solution using IEnumerable

by Marlon Hizole

An elegant approach to pagination

An Example of a (LINQ) Approach to Solve Recurring Problems

by Basem AlShabani

How to solve recurring problems using LINQ

Auto Complete with jQuery Template Plugin and AJAX

by sumit_kapadia

AutoComplete Texbox with comma separated insertions

AutoCompleteExtender working with EntityFramework! (Reload 2015)

by Eduardo Yost

Creating a Web User Control containing an AutoCompleteExtender for data through WCF (JSON) allowing to store the entity selected through EntityFramework. Entity object serialization from the server to the client and the client to the server.

Automated Serializer for WinRT Platform

by Alberto Nuti

How to serialize an object without having to manually instruct the DataContractSerializer class.

Best way to use Entity Framework

by Kundan Singh Chouhan

Simplest, best and most robust architecture.

Big n Bulky "How To" Document for ASP.NET MVC, Entity Framework, LINQ, HTML 5 and JQuery

by Bhushan Mulmule

This is terribly unorganized document with mix of MVC, Entity Framework, LINQ, HTML 5 and JQuery how tos...

Build Dynamic Order by Clause in LINQ Query in C#

by Ramesh Bevara

An overview of a helper class to build dynamic order by clause in LINQ query in C#

Build Where Clause Dynamically in Linq

by Fitim Skenderi

Build where clause dynamically in Linq

Building OrderBy Lambda Expression from Property Name in C#

by DiponRoy

Let's make a lambda expression from a property name of a particular entity, and use it for OrderBy shorting

C# Linq GroupBy ExtensionMethod Explained

by Clifford Nelson

This tip provides examples of how to use the different arguments of the Linq GroupBy extension method.

Calendar of Events in Windows Phone

by Houssem Dellai

Developing a Windows Phone app step by step

Case Sensitive Comparison of Datatables using LINQ

by Mathi Mani

In this tip, we will see how to perform case sensitive comparison of datatables using LINQ

Cast an IEnumerable to an IEnumerable(T)

by Thomas Daniels

In this tip, I tell you how to cast an IEnumerable to an IEnumerable(T)

Change Tracking an ObservableCollection

by Daniel Ziegelmiller

How to track changes in the ObservableCollection displayed in a WPF DataGrid

CheckBoxList ASP.NET MVC3

by suhas.shiv

Custom CheckBoxList in ASP.NET MVC3

ComboBox with Suggest Ability based on Substring-Search

by Physlcu$

A custom ComboBox that supports live filtering of items by Substring-Search or any other Lamda-Expression

Compare two datatable using LINQ Query

by Ramanujam Shankar

Convert Linq Query Result To DataTable

by Rami Shareef

Sometimes you need the Linq query result as datatable (I need it today)Use this: public DataTable ToDataTable(System.Data.Linq.DataContext ctx, object query) { if (query == null) { throw new ArgumentNullException("query"); ...

Convert LINQ to Entity Result to a DataTable

by Mohammad Al Hoss

Convert LINQ to Entity Result to a DataTable

by jonx

Very good stuff. Learned me a lot about how to access to the physical structure of the query.There is also a CopyToDataTable : http://msdn.microsoft.com/en-us/library/bb386921.aspx[^]And for the record here is a C# version:protected DataTable EntityToDatatable(IQueryable Result,...

Convert XML to Object using LINQ

by Naufel Basheer

Convert complex XML to an object using LINQ

Converting Array or List of data to String => made easy! (C#, MVC3, LINQ)

by Mikhail-T

A short one-line way to convert Array or List of any data into custom string via LINQ

Converting Array or List of data to String => made easy! (C#, MVC3, LINQ)

by Namlak

string blah = string.Join(",", cities.Select(c=> c.Name));

Converting Array or List of data to String => made easy! (C#, MVC3, LINQ)

by wgross

I would just use:string.Join(",", cities.Select(c=>c.Name))Since Version 4 of the Framework there is an overloaded versions of string.Join for IEnumerable too. It uses a StringBuilder internally and doesn't insert a seperator after the last element as well.I could't find the Join method...

Converting Array or List of data to String => made easy! (C#, MVC3, LINQ)

by Richard Deeming

If you're stuck with .NET 3.5, you can use the Aggregate extension method[^]:string cities_string = cities.Aggregate(new StringBuilder(), (sb, c) =>{ if (0 != sb.Length) sb.Append(", "); sb.Append(c.Name); return sb;}, sb => sb.ToString());

Converting Array or List of data to String => made easy! (C#, MVC3, LINQ)

by jarvisa

string.Join(",...

Count number of occurences of a value in a List using LINQ

by The Manoj Kumar

Did you ever face a situation where you want to calculate total number of occurrences of a value in a List object?What approach did you used for it?Did you ever try LINQ for the same? Yes, you can use it. Just look at the example below:class Program{ static void Main() ...

Create Linq to SQL connection with select, insert, delete, update

by SuhasHaridas

Create Linq to SQL connection with select, insert, delete, update

Creating Func delegates using TextToCalcExpression

by Carlos Conceição

This article how you can use TextToCalcExpression to generate Linq Expressions in runtime

Creating Presentation Objects with PresentationMapper

by HUONG Minh-Luong

How to use PresentationMapper to generate presentation objects

CRUD in ASP.NET MVC 4 with KnockOut.JS

by Indresh_Prajapati

This tip will help beginners to implement CRUD operations in ASP.NET MVC 4 with scripting language as KnockOut and Database as MS SQL 2008R2.

Cumulating values with LINQ

by Wendelius

This tip describes few examples how ro cumulate values using an extension method with LINQ

Cumulating values with LINQ

by Wendelius

This is an alternative for "Cumulating values with LINQ"

Cumulating Values with LINQ

by Matt T Heffron

This is an alternative for "Cumulating values with LINQ"

Data Tables to Formatted XML (for loops vs. LINQ to XML)

by Vishnu Kesaraju

Using LINQ to XML to convert datatables to formatted XML.

DataLoadOptions and How to use in Compiled Linq query

by Pranay Rana

DataLoadOptions and How to use in Compiled Linq query

DataReader into IEnumerable with C#

by Jaume González

How to convert any datareader into generic list.

Determine selected RadioButton in a Group of RadioButtons

by karenpayne

This code permits a developer to determine if a radio button is selected in a container such as a panel or GroupBox using syntax similar to TryParse.Requires Requires Framework 3.5 or higherExamplePrivate Sub Button1_Click() Handles Button1.Click Dim SelectedButton As New...

Duplicate Notifier for a List using ObservableCollection

by Sunil_Sebastian

Duplicate Notifier for a List using ObservableCollection.

Dynamic paging in Entity Framework

by Maninder Singh Puhi

Appropriate query to fetch required no of results from DB instead of getting all at on time for binding controls like Gridview, listview etc

Dynamic Sorting in LINQ

by Thomas Corey

Dynamically sort query results using LINQ expressions and reflection.

Dynamically Build LINQ to SQL Classes at Runtime

by oryan

Dynamically build Linq2Sql classes based off SQL table

Dynamically creating a predicate delegate

by Randy Kroeger

Created a POC that dynamically builds a predicate using Expression and Reflection.

Dynamically generate a LINQ query with a custom property

by Elvis Begluk

Dynamically generate LINQ query with a custom property.

Easy Method to Split Large XML File Using LINQ to XML

by ravgill66

Use LINQ to XML to split an XML file into a number of smaller files

EBCDIC to ASCII Converter

by Max Vagner

Converting mainframe EBCDIC to ASCII format

Editing Enumerator within foreach loop (well, not really)

by dan!sh

A simple way to edit a list or collection which is iterated in a foreach loop

EF Remove If Exists

by Robert Lindblom

Removing entity if it exists

Effective Paging Using LINQ (Sample Code)

by Sarvesh Kushwaha

Binding Gridview (or any other data control) with effective paging using LINQ

Ensure Your Code First DB is Always Initialized

by Brady Kelly

A quick and easy way to ensure that your Code First DB Initializer is always run when your app starts, not just on the first data access operation

Entity Model to Excel using LINQ in C#

by Debopam Pal

How to bring data from Entity model to Excel file using LINQ.

EntityWorker.Core - An Alternative to Entity Framework

by Alen Toma

EntityWorker.Core - an alternative to entity Framework

Excel To DataBase Table

by Sarvesh Kushwaha

Export Excel to SQL database table (Sample Code)

Expressmapper - The New .NET Mapper!

by Yuriy Anisimov

Expressmapper - lightweight, lighting fast and easy to use .NET mapper

Extended ORM generated class

by Pranay Rana

Extended ORM generated class

Filtering records from List similar to Sql IN Operator using LINQ

by Rishikesh_Singh

Filtering records from List similar to Sql IN Operator using LINQ

by Greg Sipes

An alternate solution.

Find Odds Out in a Generic List

by Rajesh Kariyavula

Find the Odds Out in A Generic List

Finding Items in a Collection that Match one of...

by Midi_Mick

Use LINQ to get the members of a collection that match the members of another collection

Finding Non-disposed Contexts in Entity Framework 6.x Applications

by Vahid_N

It's easy to forget not disposing object contexts, which leads to memory leaks and also leaves too many related connection objects not disposed as well.

Fixes to LINQ to SQL Explicit Client Evaluation which Causes Poor Performance

by scott_liu

Entity Framework Core client evaluation was disabled by default since version 3.0 because of performance.

Flatmapper

by João Matos Silva

FlatMapper is a library to import and export data from and to plain text files

Flatten a Hierarchical Collection of Objects with LINQ

by Yves Vaillancourt

Adding an extension method to LINQ to flatten any hierarchical collection

Formatting unformatted XML string in LINQ – Code snippets

by CodingLover

How to format unformatted XML string easily with LINQ.

Generate code from database

by User-Rock

LINQ to SQL

Generate Game List Based on List of Players in C#

by Andre van Dun

Generate game list based on list of players in C#

Generate XML in ASP.NET MVC5 and AngularJs using Database Value

by Md._Mehedi_Hasan

This tip will help you to generate .xml file in AngularJs and ASP.NET MVC5 using XElement of C#.

Generating sequential indices using LINQ

by Michael Agroskin

Many LINQ functions have a hidden parameter useful to generate or analyze sequential indices

Generic DropDown Control Using LINQ to SQL and Entities using Reflection

by murtaza dhari

A generic dropdown control using LINQ to SQL and Entities using Reflection

Generic LINQ Usage To Return Single Value From DataRow

by Paul Brower

This tip will allow you to return the value from column X, where column Y matches your filter

Generic repository pattern using EF with Dependency injection (Ninject)

by vijay__p

How to perform CRUD operations using generic repository with EF pattern with and dependency injection.

Get basic intuition about how LINQ works

by Delashmate

Deep Look in the basics of LINQ

Get Chunky Now

by BillWoodruff

Create collections of #n sized elements from arrays, lists, and string

Get LINQ GetCommand Parameters

by moosa pourghafari

Get LINQ GetCommand parameters.

Get Nested Property value using reflection and Linq.Expression

by Massimiliano Peluso "WeDev Limited"

Get Nested Property value using reflection and Linq.Expression

by cechode

Saw this a while back; it's simpler (dirty and wrong but... ):public static T Get(Func getDelegate, bool DefaultTOnNull = false, T defaultVal = null) where T : class{ T result = null; try { result = getDelegate(); } catch...

Get Selected CheckBoxes from container

by karenpayne

Returns all checked Checkbox controls in a Windows Form container

Getting more from your enumerations

by Gregory Gadow

With LINQ, you can retrieve an enumeration's metadata, such as its minimum and maximum values and whether it contains a given value.

Getting Property Name using LINQ

by Arun Jacob

Sometimes we want to compare the property names like,if (e.PropertyName == "FirstName"){//Do Something}But this is not type safe. If we change the property name then this won’t work as expected and also it won’t throw compile time error. For getting property name for Type safe...

How to Attach object to a different data context

by Dev_2580

For the last couple of days, working on my project for my studies I have struggled with this annoying issue regarding LINQ to SQL classes.When we update an entity within a DataContext, we can simple use something likecontext.Entity.Attach(updatedEntityInstance)The proplem is that...

How to Automatically Close Un-closed HTML Tags using C# for ASP.NET Web Applications

by Milad Ashrafi

We need this script for database based ASP.NET websites for using HTML content in post pages.

How to capture the effect of LIMIT clause in MySql using LINQ

by debolina.d

Limit the number of records that can be fetched from database based on its count like using the LIMIT clause in MySql

How to Convert LINQ Query to DataTable

by debashishPaul

How to convert LINQ query to DataTable

How to dynamically retrieve results from a LINQ Query

by -james

Iterate through the results and extract using system.reflection

How to fix "LocalDB - Requested Login failed"

by Ed Nutting

How to fix LocalDB / SQL Server: "Cannot open database "XYZ" requested by the login. The login failed. Login failed for user ABC"

How To Insert Records Into A Table That Has No Primary Key, using LINQ to SQL?

by karimbaig5

This tip provides an idea about how to insert a record into a table having no primary key using LINQ to SQL.

How to log your LINQ query

by Pranay Rana

Log your LINQ query

How to log your LINQ query

by jim lahey

I prefer to use ToTraceString() on the ObjectQuery:http://msdn.microsoft.com/en-us/library/system.data.objects.objectquery.totracestring.aspx[^]It's less intrusive as I don't have to instantiate and dispose the StreamWriter and I have more control over where and how I log the resultant...

How to Return/Serialize JSON in VB.NET

by The Myth

How to return Json in VB.NET in multiple ways

How to serialize list of linq entities (ex. from DBML)

by EuGenius_Krivbass

Today I was trying to save list of entities those were generated by DBMLThis code shows how you can store your list in XML string and put it in ViewState, after that you get your list back.Using the CodeYou can use this code as you need.Here is class Serializatorpublic class...

How to set the connection string in your LINQ dbml file dynamically based on web.config

by maq_rohit

How to set the connection string in your LINQ dbml file dynamically based on web.config

Immediate Loading Relational Data in LINQ to SQL

by Arun Jacob

In LINQ to SQL the relational data is loading only when we refer that data, other terms its lazy loading of data.But we can load relational data ,suppose we have an Employee Table and also having an Employee details table related to Employee Table, we can load that relational data using...

Importing Excel XLS Files to Database Tables using Linq to SQL

by gardnerp

This tip shows how to import XLS data to a SQL database using Link to SQL.

Introduction to Linq To WMI with Code Generation GUI

by John Wigger

Left Outer Join extension for Entity Framework

by Tony Sherlock

Snippet for Left Outer Join, Entity Framework

Let in LinQ

by Juan Francisco Morales Larios

Let in LINQ

Like Magic, No Strings Attached

by dgDavidGreene

Helper utility replaces magic string property names.

LINQ - GroupBy

by Srinivasu Pemma

This tip provides an easy way of dealing with different types of data sources for LINQ Group By taken from my blog http://www.srinetinfo.com/2012/12/linq-group-by.html

LINQ (Language-Integrated Query)

by TalentTuner

In this article, We will perform basic linq operations using LINQ To Objects and LINQ To Entity

LINQ (Single, SingleOrDefault)

by Programm3r

I sometimes get asked how to get a single object from a generic list based on a LINQ query. i.e. Performing a LINQ query on a generic collection and then returning only the single instance without looping through the collection. Well this is how I do it:public class Person{ public...

LINQ as Declarative Programming

by Ryszard Dżegan

How to take full advantage of declarative paradigm by using LINQ.

LINQ Basics

by Uladzislau Baryshchyk

Basics of the embedded LINQ language

Linq Deferred Execution

by Pranay Rana

To understand how execution take place consider below code: //Query not going to execute at this pointvar query = from customer in db.Customers where customer.City == "Paris" select customer; Most of the people think that the query gets...

LINQ Extension Methods for Rescue

by Hisham Abdullah Bin Ateya

LINQ Extensions methods that may help you a lot

LINQ for JavaScript

by Super Lloyd

Adding LINQ goodness to Javascript?

LINQ is for querying! Not for manipulation.

by Delashmate

Notes regarding LINQ abstraction.

Linq Joins with SelectMany

by Pranay Rana

Linq Joins with SelectMany

LINQ One-liner to Get An Array Containing Month Names

by Steven Oberholzer

The following tip contains a simple way to get an array of month names. It is a one liner, a rather trivial task - but I thought it was too cool not to share :).

Linq Queries Examples Using Method And Query Syntax

by Mohd Manzoor Ahmed

Linq Queries Examples Using Method And Query Syntax

LINQ Query Case Sensitivity

by Winstan

Case sensitive LINQ query

LINQ to CSV

by Hisham Abdullah Bin Ateya

LINQ to CSV files.

LINQ To Entity Outer Join

by Mr Orange

Introduction...

LINQ to JQuery

by Jaume González

Extends Arrays in JavaScript, adding the main domain and filtering functions of LINQ

LINQ to SQL – Execute SQL Queries

by A Mahesh

LINQ to SQL – Execute SQL Queries

LINQ to SQL - Mapping Stored Procedure with Multiple Results

by Hiren Khirsaria

Mapping Stored Procedure with DBML to get multiple results from Stored Procedure

LINQ To SQL Using C#

by Ehtesham Mehmood

LINQ to SQL using C#

Linq, Lambda and Expressions

by aboubkr90

A way around "The LINQ expression node type 'Invoke' is not supported in LINQ to Entities"

Make Comma Separated List the Easy Way

by David_Wimbley

How to make a comma separated string using Linq

Mastering LINQ by Samples - LINQ Basics

by alrosan

Max() extension method but using a separate scorer and selector

by Phil Martin

This does the same as Enumerable.Max(), but allows for a second function to select the result, rather than returning the usually useless score./// /// Transforms each item of the sequence to a double score using the function, and finds the maximum scored...

Minimal web.config to use Linq in web projects

by e.bonavero-miller

make sure that web.config contains these config sections: ...

MongoDB C# - DB Side Projection

by A. Fry

MonogoDB server side projection using the C# driver

Most Useful VS2013 Tricks and Shortcuts!!

by Pritam Deshmukh

This tip elaborates few useful tricks and shortcuts of VS 2013 mainly for professional edition (You can find them with Ultimate version too).

Multiple Indexers in C#

by Sion Cohen

An elegant programmatic solution for having multiple indexers in C#

MVC Attributes

by VijayRana

Some useful MVC Attributes (Bind Attribute, HandleError Attribute, HiddenInput Attribute, Remote Attribute)

New methods of coding (at least for some)

by karenpayne

Using newer conventions of coding in VS2010 and higher

ObservableLinq

by Csaba Fábián

An open source library of Linq operators on ObservableCollection

OData

by me.ajaykumar

OData

Optimizing linq queries that retrieve a single element

by taha bahraminezhad Jooneghani

Problem around .first() method in EF and a good solution

Paging DataGridView in C# using LINQ

by mohammad amiri

Paging DataGridView using LINQ in C#.

Pivot Table Using Linq Entity and SQL Server 2008 R2 for Dynamic Columns

by Avinash Narnaware

How to create Pivot Table in SQL Server 2008 R2 and in C# Linq to Entity Framework in a step by step manner with two different instances.

PropertyMapper

by Member 3531622

Get rid of trivial mapping between objects like mapping between obj1.City and obj2.Town or between properties with the same name

Query Hierarchical DataTable

by Wendelius

This tip shows one way to query hierarchical data from a DataTable by using an AsTree() method.

Querying DataSet With LINQ in ASP.NET

by HemendraSingh88

Hi, here we will see how to query a DataSet with LINQ(Language Integrated Query).

Read XML Files and Insert into Database Table

by Gunaprasad Shetty

The tip provides the code snippet for inserting a huge XML file with details such as node level, node value, node desc and node child, etc.The snippet provides the solution for recursive reading of node and provides the value of XML nodes along with its value.

Real-time statistics with Rx (Statistical Demo App 1 of 2)

by John L. Vidal

Know how an event in your app is performing by using Reactive Extensions

Refactor C# code to become more expressive

by Rafael Nicoletti

Refactor C# code to become more expressive

Remove duplicate entries from string array

by karenpayne

This VS2008 or higher extension uses a LINQ statement to remove duplicate items from a string array but is not case sensitive, also you might like to leave the sort/order-by in the extension or remove it.ExampleDim Names() As String = {"Bob", "Mary", "bob", "Bob", "Jane", "Kevin",...

Replacing foreach loop with LINQ

by Delashmate

Advantages of replacing a foreach loop with LINQ

Replacing foreach loop with LINQ

by George Swan

Isn't it possible to remove the from and select statements by using a lambda expression?var bestStudents=students.Where(s=>s.Grade>9);

Replacing foreach loop with LINQ

by Shmuel Zang

For replacing foreach loop, for a non-query operation, just for performing an operation on each element in the collection, we can use the ForEach method, like the following:students.ToList().ForEach(s => { s.Grade += 10;});

Resampling and merging time series data using LINQ

by Ashley Davis

The technique presented here is a simple method of resampling and aggregating time series.

Re-usability of View in MVC

by Nithila Shanmugananthan

Re-usability of view in MVC

Run SQL queries on datatables with SqlToDataset

by DerStauner

With this library it is possible to query datatables with SQL commands.

Save Your Settings in a File in JSON and using LINQ for Read and Save

by Dario Picca

Save Key and Value in JSONformat using C# and LINQ

Search XML Using LINQ in .NET

by yrimal

How to search XML content using LINQ in .NET.

See the SQL Generated by LINQ

by MarkLTX

When using LINQ to SQL, it can be very useful to see the SQL commands that are generated by your LINQ expressions. Sometimes the results are surprising and you might be able to improve performance by tweaking the LINQ.All you have to do is set the Log property of the DataContext object. ...

See the SQL Generated by LINQ

by Henry Minute

Or, there's always Scott Guthrie's LINQ To SQL Debug Visualizer[^].[Edit]While I'm posting links there is a nice utility that can output the generated SQL to the Debug Window in VS written by Kris Vandermotten.You can get it here[^].To use it: MyDataContext db = new...

See the SQL Generated by LINQ

by Philippe Mori

LINQPad is an interesting tool to try queries.LINQPad[^]Perfect tool to try out some alternatives for complex queries. As we can see generated queries and elapsed time, it help a lot to help having fast queries for complex requests.

See the SQL Generated by LINQ

by AspDotNetDev

If you are the type that likes to debug production code, you can use SQL Profiler to find queries generated by your LINQ statements. This is a technique I recently used because it was so simple and did not require me to recompile anything.Note that StefanHam already posted this alternate...

Select Recursive Extension method

by Magnus_

An extension method to the IEnumerable`1 interface that can select all children recursively of an entity in a tree like structure

Select Recursive Extension method

by John Adams

Magnus, I really like the idea! I believe your original idea (posted @ http://www.codeproject.com/KB/linq/LinqToTree.aspx) is even better for the general case - probably better than the solution in the article - it does feel more generic while still being very easy to use.I'm sure you may...

Selecting Distinct Records Using LINQ

by Eric Shandil

How to get dictinct records from a datatable in .NET.

Setup your ASP.NET Membership Login in MVC (or any project you want)

by Alexandre Paula

aspnet Membership Login in any project you want.

SharePoint 2013 Data Access Layer using SPMetal

by Ahmad F Hassan

Step by step, creating LINQ to SharePoint Data Access Layer using SPMetal

Silverlight, PLINQ, and my take on a Semaphore variant.

by Alex Perepletov

Simple jQuery Carousel Matrix 2D AJAX

by Dav Zen

Simple and easy to use jQuery matrix 2D.

SimpleThreading Makes Threading Easy!

by Sharp Ninja

Threading can be a daunting topic. This library takes much of the worry (and mistakes) out of multi-threaded application programming.

Slow LINQ Methods

by George Jonsson

LINQ methods can be slow inside loops as this little demo shows.

Solution to annoying error 0029 - Cannot convert type 'T' to 'System.Data.Linq.Link'

by Itai Basel

Finally found a solution to the annoying LINQ to SQL dbml error: CS0029 : Cannot implicitly convert type 'int' to 'System.Data.Linq.Link'.

Sort on multiple values with LINQ

by User 6619207

SortedSet Linq Extension Method

by Kevin Marois

This simple extension method allows you to create a SortedSet from a Linq query

SortedSet Linq Extension Method

by Matt T Heffron

Since SortedSet has a constructor that takes an IEnumerable parameter, the ToSortedSet extension method can be greatly simplified:public static SortedSet ToSortedSet(this IEnumerable t){ return new SortedSet(t);}

Sorting List using DataTable vs. Linq vs. Tuple

by Bhis

Various ways to sort list and compare results

String concatenation using LINQ to create a CSV/PSV string

by JP_Rocks

A tip to concatenate a set of strings using comma/pipe

String concatenation using LINQ to create a CSV/PSV string

by Mohammad A Rahman

The idea was good, but I think we could probably do something like below:public static string UsingStringJoin(IEnumerable sList, string separator){ return sList.Any() ? string.Join(separator, sList.ToArray()) : string.Empty;}public static string...

String concatenation using LINQ to create a CSV/PSV string

by Mario Majčica

Or even better:public static string Join(this IList list, string joinString) { StringBuilder result = new StringBuilder(); int listCount = list.Count; int listCountMinusOne = listCount - 1; if (list != null && listCount > 0) { ...

String concatenation using LINQ to create a CSV/PSV string

by Erich Ledesma

I rather like IEnumerable than IList, parameters should be as general as posible. I think it's really getting very fun up here. Here's my choice, just for strings.public static string Join(this IEnumerable parts, string separator){ if (! parts.Any()) return...

String concatenation using LINQ to create a CSV/PSV string

by George Swan

You can use the Aggregate method with a StringBuilder. I've modified Eric's alternative in order to save a bit of code. Only one return statement is needed as an empty StringBuilder returns an empty string.public static string Join(this IEnumerable parts, string separator) { ...

Subset - Sum Problem with Numeric Collections

by Matt T Heffron

This is an alternative for "Subset - Sum Problem with Integer Arrays "

Take the Data of “GRIDVIEW” to Excel. The data is in ItemsSource as AnonymousType, Table or DataView

by wengqian

Taking data of Gridview to Excel

The Elegant Art of Programming

by Erol Esen

This tip uses the elegant LINQ to solve pesky daily problems.

The Elegant Art of Programming

by PIEBALDconsult

This is an alternative for "The Elegant Art of Programming"

The Elegant Art of Programming

by PIEBALDconsult

This is an alternative for "The Elegant Art of Programming"

The Elegant Art of Programming

by Guillaume Leparmentier

This is an alternative for "The Elegant Art of Programming"

The Elegant Art of Programming

by Juan Pablo G.C.

This is an alternative for "The Elegant Art of Programming"

Tip – Walk Before You Can Run

by Toby Steed

Walk before you can run

To Generate XML File from Datatable using LINQ

by puja11191

This tip shows how can we generate and save XML files

Transform a List To Dictionary of Lists

by Bilel Msekni

How to transform a list to a dictionary in 3 different ways?

TRICK: Xml Literals for C#

by Jaime Olivares

Workaround to mimic VB.net's Xml Literals in C#

Understand Lambda Expressions in 3 Minutes

by Dan Avidar

Lambda expressions short tutorial

Understand Lambda Expressions in 3 Minutes (Continuation)

by Mr.PoorEnglish

This is an alternative for "Understand Lambda Expressions in 3 minutes"

Uploading multiple files and creating a Zip File in ASP.NET with C#

by Mannava Siva Aditya

Uploading multiple files and creating a Zip file in ASP.NET with C#.

Using `Environment.SpecialFolder` to Maximize Portability

by _Noctis_

How to avoid some hardcoded paths with the uses of Environment.UserName

Using basic LINQ commands to query objects in memory

by Ismael Almonte

Use basic LINQ commands to manipulate and query .net objects.

Using Effort - Entity Framework Unit Testing Tool

by Roger C Moore

This tip is a guide for using the Codeplex project Effort for testing Entity Framework applications without requiring the unit tests to actually hit the SQL Server database.

Using Extension Methods To Avoid XML Problems

by #realJSOP

Extension methods can help you avoid sticky situations.

Using Extension Methods To Avoid XML Problems

by Rama Krishna Vavilala

I will just make it a little more compact by omitting the Contains method:public static string GetValue(this XElement root, string name, string defaultValue) { return (string)root.Elements(name).FirstOrDefault() ?? defaultValue; }The explicit operators for XElement...

Using Extension Methods To Avoid XML Problems

by Richard Deeming

You can avoid all of this by using the explicit cast operators:public XElement Element{ set { this.MyVar1 = (string)value.Element("MyVar1") ?? "NO VALUE"; this.MyVar2 = (string)value.Element("MyVar2") ?? "NOVAL"; }}Both XElement and XAttribute define...

Using Extension Methods To Avoid XML Problems

by Richard Deeming

This is an alternative for "Using Extension Methods To Avoid XML Problems"

Using LINQ to read delimited text files

by The Manoj Kumar

Did you ever face a situation where you want to read a delimited file (CSV or any similar format) and want to filter the records on the basis of some conditions (by checking some values against columns).For example, let's assume that Data.txt file contains the following...

Using SQL Bulk Copy with your LINQ-to-Entities datacontext - Part 1

by Måns Tånneryd

This tip shows how to significantly speed up inserts of large amounts of data using the entity framework.

Using SQL bulk copy with your LINQ-to-Entities datacontext - Part 2

by Måns Tånneryd

This tip shows how to speed up inserts using POCO objects and the entity framework version 5.

Using SQL bulk copy with your LINQ-to-SQL datacontext

by Måns Tånneryd

How to use bulk insert with your LINQ-to-SQL datacontext

Using SQL bulk copy with your LINQ-to-SQL datacontext

by RupertC

If the order of your columns is different in the LINQ to SQL class from that in the database, then you also need to add a column mapping to the bulk copier. Otherwise you get mysterious errors in some of the loaded columns!In my simple fix, I assume that the names match even if the order may...

Verify Resources Used by DisplayAttribute

by Christ Akkermans

Code for verifying the resources used by DisplayAttribute in order to catch any missing resource strings

Web API Data Structure Controller

by xibao

Generate class definition for Web API Service Models.

WebMonster

by ravichaitanya.m

The code shown here allows a user to get all public tweets of her /his liking without logging into Twitter and search for tweets with keywords. It also allows the user to search for his/her friends who are tagged in his/her albums.

When to use PLINQ vs LINQ

by Tony Dubey

This code demonstrate pros and cons of PLINQ as compared to LINQ

Why C# interface inheritance makes sense: see LINQ...

by Andreas Gieriet

How Linq extension methods benefit from interfaces inheriting from interfaces

Working with LINQ to Entities & LINQ to DataTable

by ShaikAnwar

This topic gives us an idea of how to write Linq queries on Entities & DataTable. This covers some basic querying and also usage of joins and group by using LINQ.

WPF and MVVM pattern

by Oussama_Kahoul

Introduction to WPF technology and the MVVM design pattern

Yet Another Convertor From Infix To Postfix Expressions!

by Dariush Tasdighi

A very powerful and customizable source code that converts the Infix to Postfix expression.