Monthly Archives: March 2008

Beginning “LINQ to SQL” using Visual Studio 2008

Hai,   My new article on "LINQ to SQL" got published here http://www.aspfree.com/c/a/.NET/Beginning-LINQ-to-SQL-Using-Visual-Studio-2008/   It covers all the following topics:   -> Developing a simple "LINQ to SQL" application without using "LINQ to SQL" designer -> Retrieve and update information … Continue reading

Posted in LINQ/EF | Tagged , | Leave a comment

TIP: Viewing the generated SQL of LINQ statements

Even though LINQ uses the familar syntax as of SQL, it is not the same SQL generated at run-time.  To view the SQL generated from LINQ, we can use "Log" property of "DataContext" in the following manner:                 Dim obj … Continue reading

Posted in LINQ/EF | Tagged , , | Leave a comment

TIP: Modifying Connection String dynamically for a strongly typed dataset in a different assembly

Imagine, I am working on a Visual Studio 2005/2008 solution with class library project (DAL) and Web Application Project (ASP.NET).  Say, the DAL is being developed using Dataset Designer with different Strongly Typed DataSets/DataTables together with TableAdapters.  Then I would … Continue reading

Posted in ASP.NET | Tagged , | Leave a comment