Browse by Tags

It quite so happen that you are working with XML where you are expecting a specific element in every set. But somehow that is missing in some of the sets. Now at runtime you would get an error.. The XML file which I am targeting <? xml version = " 1.0 " encoding = " utf-8 " ?>...

Many of us are aware of LINQ today. LINQ is an amazing programming language feature. During my discussions I find a lot of myths around understanding. Here I have tried to demonstrate from some basics of C# 3.0 language enhancements to delegate, anonymous type, lambda expression and finally LINQ. How...

While I was reading the book LINQ in Action , I found this chapter. Below is how we can do in LINQ to SQL. The scenario is if you want to create a LINQ and pass the where clause based on user input from UI, you need to write different queries. Instead, how you can do it in single LINQ. I have used the...

Visual Studio 2010 has new API for LINQ (Language Integrated Query). This helps us to implement the power of Parallel Computing in declarative manner. LINQ without Parallel Extension It will take 3 sec for 28 thousand elements. static void Main( string [] args) { Stopwatch sw = Stopwatch...

Getting data from CSV is one of the mostly used business in applications/tools development. Here how we can do it in LINQ, You have a table called Emp with the below details, CREATE TABLE [dbo] . [Emp] ( [Id] [int] IDENTITY ( 1 , 1 ) NOT NULL, [FirstName] [varchar] ( 50 ) NOT NULL, ...

Annotations are used for private use. It does not directly associated and known as Black Box in XML world. This can also be considered as meta tag. Below is an example on how it can be handled. I have created a sample Windows Applications and will try to capture my understanding. /// <summary>...

I have spent a while with LINQ and still feel very new whenever I explore some new power. Here I am going to describe you how LINQ uniformly allows you write for the various types of data. In-memory data source ++++++++++++++++ List < int > arrInt = new List < int > { 1, 2, 3...

In my previous text based blog I had promised to share the recording. Here it is and I am using Silverlight Streaming Namoskar!!!

Understanding Compiled Query connects me to my experience in C# 3.0. Based on my personal understanding I am discussing it. You may be aware of Func<>. And you know it is a flexible delegate which allows you create reusable functions. Exactly the same way we can create compiled query so that...

Must read http://www.sidarok.com/web/blog/content/2008/05/02/10-tips-to-improve-your-linq-to-sql-application-performance.html Namoskar!!!

In LINQ to SQL it is not that easy thing to achieve as compared to other features. Let us assume you have a Stored Procedure like, Case 1: With Output Parameter CREATE PROCEDURE [dbo] . [GetEmployeeCount] @OutVal DateTime OUTPUT AS BEGIN SELECT @OutVal = GetDate () END You need...

Most of the transactional scenario, you may need to add the transaction to some table for ref. many apps does it for admin perspective. Problem You can do it in LINQ to SQL with ChangeSet but the problem is with Inserts. It does not give you the Identity field value until and unless you call...

While browsing the features I found an interesting extension method called “Zip”. How it works, let’s check it. List < string > names = new List < string > { "Debajyoti" , "Sumitra" , "Wriju" , "Writam" , "Tupur" }; List < int > ages = new List < int >{ 67, 58,...

There is a correction for this Post , so do I have changed the title. Thanks to Chris Love who pointed me the faults with earlier post, I got few question on some of the popular paging methods of LINQ which does not work on LINQ to Entity. This is by design and quite logical. In LINQ to SQL scenario...

Relationship and getting data from Entity Framework using Northwind database Simple Query using ( NorthwindEntities ctx = new NorthwindEntities ()) { var query = from o in ctx.Orders select o.OrderID; foreach ( var k in query) { Console .WriteLine(k); } } ...

Few days back I had written an article on Insert/Update/Delete for simple standalone tables at ADO.NET Entity: Insert Update and Delete . Now after that many of you had requested me to put article on how it works with relationship. Here I will use a database created by me. There will be two tables...

For small blogs, it requires more references and explanation, which sometimes are redundant. So I thought of writing single blog which is combination of topics more or less related to one thing. I am exploring ADO.NET Entity Framework and have been trying things out there. Here I am planning to...

ADO.NET is our contemporary data access component and now we have written many applications. Now there has been a lot of talk on LINQ to SQL. So we are little skeptical about this component and trying to find some relation between existing ADO.NET technology. Purpose of this post is to give some...

ADO.NET and LINQ to SQL Describes the relationship of ADO.NET and LINQ to SQL. Analyzing LINQ to SQL Source Code Describes how to analyze LINQ to SQL mapping by generating and viewing source code from the Northwind sample database. Customizing Insert, Update, and Delete Operations ...

Normal 0 false false false EN-US X-NONE X-NONE ...

Normal 0 false false false EN-US X-NONE X-NONE ...

ADO.NET Entity Framework have evolved since we have released it first time. Now with the Visual Studio 2008 if you install the .NET Framework 3.5 SP1 and Visual Studio 2008 SP1 you will get the fully functional version of ADO.NET Entity Framework. This is post Beta 3 release. To create a .edmx file...

You can create your application use LINQ to SQL and make it N-Tier. Go ahead and watch out the MSDN Documents N-Tier and Remote Applications with LINQ to SQL LINQ to SQL N-Tier with ASP.NET LINQ to SQL N-Tier with Web Services LINQ to SQL with Tightly-Coupled Client-Server Applications ...

This question arises in one of discussions. If you have a XML document with “xmlns” then LINQ to XML does not return any IEnumerable<T> J . This is strange but true for XPath and XQuery. There is a trick to get it done, Let us assume that you have a XML as follows, <? xml version =...

IEnumerable<T> and IQueryable<T> are the two most used terms of any LINQ discussion. What I am trying to here is that I am trying to simplify the two interfaces depending on their behavior. In LINQ world we generally have few providers available within .NET Framework, like LINQ to Object...