July 2007 - Posts
Data Points: ADO.NET Entity Framework Overview Data Points: Contrasting the ADO.NET DataReader and DataSet by John Papa Data Points: Data Bound Applications with ADO.NET and Custom Objects by John Papa ADO.NET: Tackle Data Concurrency Exceptions Using
Read More...
Choose the one you want Visual Studio 2008 Standard Edition Beta 2 Visual Studio 2008 Professional Edition Beta 2 Visual Studio Team System 2008 - Team Suite Beta 2 Visual Studio Team System 2008 - Team Foundation Server Beta 2 Visual Studio Team System
Read More...
LINQ: .NET Language Integrated Query By Don Box, Anders Hejlsberg LINQ to SQL: .NET Language-Integrated Query for Relational Data By Dinesh Kulkarni , Luca Bolognese, Matt Warren , Anders Hejlsberg , Kit George .NET Language-Integrated Query for XML Data
Read More...
LINQ to SQL is pure Object Relational Model introduced by Microsoft. It used mapping mechanism to represent Relational Components Object Component Table Class Column Property Foreign-key relationship Association It gets the user input through this object
Read More...
LINQ to SQL executes or generated SQL statement only when you run a foreach statement or you perform to ToList() method to it. If you need to display the output multiple times without executing the real database query, you can store them in memory. This
Read More...
LINQ to SQL has support for both deferred and immediate loading. By default it supports deferred loading but you can configure your code to load the data immediately. Let’s consider the Northwind database. As we know the there are two tables Customer
Read More...
Thanks to everyone who supported me in this BLOGGING journey. I started blogging back in May 2006, was not very regular blogger till September 2006. I blog to share my .NET adventure, starting from C# 2005 to LINQ (C# 3.0). I use them to convey the interest
Read More...
In LINQ to SQL you also can send the DML query to perform the quick database modification. Caution!!! It is not recommended as it does not support object model so has no compile time checking. static void Main ( string [] args) { string strConnection
Read More...
LINQ to SQL support deleting data through object. Continuing with my previous blog on INSERT , let me discuss about the delete method static void Main ( string [] args) { string strConnection = @"Connection String" ; TestDB db = new TestDB (strConnection);
Read More...
LINQ to SQL support updating data through object. Continuing with my previous blog on INSERT , let me discuss about the update method static void Main ( string [] args) { string strConnection = @"Connection String" ; TestDB db = new TestDB (strConnection);
Read More...
LINQ to SQL support inserting data through object. using System; using System.Collections.Generic; using System.Linq; using System.Text; using System.Data.Linq; namespace Linq2Sql_demo_doc { /// <summary> /// Class to represent the SQL Server table
Read More...
INSERT/DELETE/UPDATE can be performed in LINQ to SQL through normal T-SQL DML queries, static void Main ( string [] args) { NorthwindDBDataContext db = new NorthwindDBDataContext (); var query = db.ExecuteCommand( "YOUR DML Query" , "Your Parameter" );
Read More...
Yes, you can run normal SQL queries in LINQ to SQL. Sample looks like (but not recommended as you do not have statement completion and validation) static void Main ( string [] args) { NorthwindDBDataContext db = new NorthwindDBDataContext (); var query
Read More...
I have recorded a small 34 minutes session on LINQ to SQL. Covering the topics on > Object Model > Select/Insert/Update/Delete > Stored Procedure Support > Linq to Sql designer Video: Overview of Linq to Sql Namoskar!!!
Read More...
Join members of the Visual Studio Team System product group to discuss features available in Visual Studio Team Foundation Server, Team Editions for Architects, Developers, Database Pros, and Testers. In addition, discuss what's new in the upcoming Orcas
Read More...
Overview This CTP contains updates to the ADO.NET Entity Framework since the Visual Studio Codename "Orcas" Beta 1 release, including changes in Object Services, Query, Entity Client, and the Entity Data Model Wizard in Visual Studio. Some of the new
Read More...
Getting data from SQL, XML and Object and joining them using Language Integrated Query is something you might be looking for. I have created a small application which brings data from SQL Server (table name is Employee), XML (file name is Department.xml)
Read More...
