Browse by Tags
All Tags »
C# 3.0 (RSS)
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...
Purpose Users are allowed to pass Product Key while installing in .msi. During that we want to capture it for registration to avoid piracy. Challenges When we use “Customer Information” dialog in “Start” action, it has “SerialNumberTemplate”. But capturing
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...
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...
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...
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
Read More...
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
Read More...
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
Read More...
