Browse by Tags
All Tags »
LINQ (RSS)
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
Read More...
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]
Read More...
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
Read More...
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
Read More...
In my previous text based blog I had promised to share the recording. Here it is and I am using Silverlight Streaming Namoskar!!!
Read More...
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
Read More...
Must read http://www.sidarok.com/web/blog/content/2008/05/02/10-tips-to-improve-your-linq-to-sql-application-performance.html Namoskar!!!
Read More...
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
Read More...
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
Read More...
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
Read More...
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
Read More...
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);
Read More...
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
Read More...
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
Read More...
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.
Read More...
