Browse by Tags
All Tags »
C# 3.0 (
RSS)
C# 3.0 Enhancements that Build LINQ – Slides and Demos Earlier this week, I delivered a session in the IDF Developers Forum called: How LINQ Works? Diving into C# 3.0 Enhancements that Build LINQ . As promised, the slide decks and demos are available through my presentations page . Enjoy!
ADO.Net Entity Framework Oracle Provider Support One of the great promises of the ADO.Net Entity Framework is that is supports working with different databases while still getting pretty much the same functionality. E-SQL, the Entity SQL dialect being used in ADO.Net Entity Framework is database independent, and supports this vision. Many customers that use Oracle databases are looking for an ADO.Net Entity Framework Oracle Provider since it was first previewed in 2006. With the release of ADO.Net...
LINQ to SQL Concurrency - ChangeConflictException Row not found or changed If we create a small model of the Northwind database, and we try to modify one of the customers (lets take ALFKI for example): NorthwindDataContext db = new NorthwindDataContext (); Customer alfki = db.Customers.Single(c => c.CustomerID == "ALFKI" ); alfki.City = "London" ; db.SubmitChanges(); We will see that the update command that is created by the run time is: UPDATE Customers...
LINQ to SQL Breaking Changes from Visual Studio 2008 Beta 2 to RTM With the release of Visual Studio 2008 , there are some changes moving LINQ to SQL projects from Visual Studio 2008 Beta 2 to Visual Studio 2008 RTM. There was already writen by Dinesh Kulkarni , the PM of LINQ to SQL in this post , but now they are officially published in a complete document. Download it here . Enjoy!
C# 3.0, LINQ and LINQ to SQL Hands on Labs for Visual Studio 2008 RTM After the release of Visual Studio 2008 RTM, the Visual Studio 2008 Samples page on MSDN was update accordingly. You can find few Hands on Labs there that will help you practice the new language features: C# 3.0 Language Enhancements Hands On Lab LINQ Hands On Labs LINQ to SQL Hands on Lab Additionally, you can Download Visual Studio 2008 and .NET Framework 3.5 Training Kit for other new technologies around. Enjoy!
Visual Studio 2008 RTM Live and Kicking! Yesterday, after the announcement that Visual Studio 2008 RTM Is Available for MSDN Subscribers , I downloaded and installed it, following Scott Guthrie's Installation Suggestions . The installation ran over the night so I can't really tell how long it took, but as of this morning - Visual Studio 2008 RTM Live and Kicking! Enjoy!
See what's in the Training Kit for Visual Studio 2008 and .Net Framework 3.5, and get the links for downloading....
Commonly Used Types and Namespaces in .Net Framework 3.5 If you want to make sure you've read enough articles and blog posts about .Net Framework 3.5, or you just happen to have an empty wall in your office, download the Commonly Used Types and Namespaces in .Net Framework 3.5 poster. Enjoy!
Linq to SQL Session @ Developer Academy 2 Over the last months I've been using Linq to SQL in Visual Studio 2008 through its various releases. In the next Developers Conference here in Israel - Developer Academy 2, I will be giving a session that's all about Linq to SQL. Next Generation Relational Data Access with LINQ to SQL In Visual Studio 2008, Microsoft brings Next Generation Data Access with LINQ to SQL , a part of the LINQ project. LINQ to SQL is designed to integrate relational data...
All About ObjectDumper Why do I need it for? In many demos, we print objects to the Console window. If the object is a very simple one, like: public class Vehicle { public string VehicleID { get ; set ; } public int Year { get ; set ; } public string Model { get ; set ; } } than it is very easy: Vehicle v = new Vehicle { VehicleID = "30-804-15" , Model = "Mazda 3" , Year = 2006 }; Console .WriteLine( "VehicleID = {0}, Model = {1}, Year = {2}" , v.VehicleID, v.Model,...
Linq to SQL Features in RTM Dinesh Kulkarni, the current program manager of Linq to SQL, has lately posted in the Linq Project MSDN Forum about the key changes moving from Visual Studio 2008 Beta 2 to RTM. The list of changes contain some changes and features , as well as change in the behavior of the Attach method . Today, Dinesh has posted about the list of features which will not be in Linq to SQL v1. From his post: Support for other databases with or without a public provider model. Out-of-the...
Linq to SQL Like Operator As a response for customer's question, I decided to write about using Like Operator in Linq to SQL queries. Starting from a simple query from Northwind Database; var query = from c in ctx.Customers where c.City == "London" select c; The query that will be sent to the database will be: SELECT CustomerID, CompanyName, ... FROM dbo.Customers WHERE City = [London] There are some ways to write a Linq query that reaults in using Like Operator in the SQL statement...
Linq to SQL Deferred Loading - Lazy Load Consider the Blog Site database I used in previous posts about Linq to SQL : Linq to SQL Deferred Loading If we query for the available blogs in the site using Linq to SQL, the query should look like this: BlogDataContext ctx = new BlogDataContext (...); var query = from b in ctx.Blogs select b; foreach ( Blog b in query) { Console .WriteLine( "{0}" , b.BlogName); } This Linq query will result in the following SQL statement being sent to the DB:...
Linq to SQL Stored Procedures with Multiple Results - IMultipleResults Continuing my post series about Linq to SQL , this post talks about using stored procedures that return multiple result sets in Linq to SQL. If you missed any of my previous posts about Linq to SQL, here is a reminder: Linq to SQL Attribute Based Mapping Linq to SQL Xml Based Mapping How To: Model Inheritance in Databases Linq to SQL Inheritance Linq to SQL Stored Procedures Sql Server supports returning more than a single result...
Linq to SQL Stored Procedures Continuing my Linq to SQL post series, this post talks about using Linq to SQL Stored Procedures . Note that this post is being written based on Visual Studio 2008 Beta 2 release, so if you're using later releases, things might be a little different. To demonstrate using stored procedures, I am using a blog site database schema: and in order to retrieve the posts that belongs to a certain category, I have also created a stored procedure: CREATE PROCEDURE dbo.GetPostsByCategory...
More Posts
Next page »