John Papa [MVP C#]

Browse by Tags

• .NET
• ADO.NET
• EF & LINQ
• Ent Lib
• Mobile Dev
• Reviews
• Silverlight

• Visual Studio 2008 and .NET 3.5 SP 1 Beta Download

  Soma announced this morning that Visual Studio 2008 and .NET 3.5 SP 1 is now ready and can be downloaded . This includes several updates, includes support for SQL Server 2008, and has a few new products including the Entity Framework, LINQ to Entities... Posted May 12 2008, 01:29 PM by John Papa with | with no comments Filed under: .NET, ADO.NET, EF & LINQ , SQL

• Silverlight, WCF and LINQ to SQL

  I've had some requests lately to write some articles that work with LINQ to SQL. I've ben focusing on the Entity Framework a lot due to its vast nature and that fact that its still relatively unknown to many people. So I am going to work on a... Posted May 07 2008, 06:31 PM by John Papa with | with 4 comment(s) Filed under: .NET, ADO.NET, EF & LINQ , Silverlight, SQL

• Designing SQL Server's Common Table Expressions (CTE's)

  My October 2007 Data Points column has been posted to the MSDN Magazine web site . This edition is titled "SQL Server Common Table Expressions". In this article I focus on using CTEs to address common development scenarios. - describing how... Posted Sep 12 2007, 06:29 PM by John Papa with | with no comments Filed under: SQL

• Data Access "Practically Done"

  Full Day of Practically Done Data Access Posted Jun 22 2007, 12:17 PM by John Papa with | with 3 comment(s) Filed under: .NET, ADO.NET, EF & LINQ , Ent Lib, SQL

• Using SMO for DDL with SQL Server

  My June 2007 Data Points column has been posted to the MSDN Magazine web site . This edition is titled "SQL Server Management Objects" . Here is an excerpt from the article: "Not only must database developers query and manipulate data,... Posted May 25 2007, 10:48 AM by John Papa with | with 2 comment(s) Filed under: SQL

• Disabling Constraints and Triggers

  My April 2007 Data Points column has been posted to the MSDN Magazine web site . This edition is titled "Disabling Constraints and Triggers" . Posted Mar 14 2007, 09:05 AM by John Papa with | with no comments Filed under: SQL

• Entity SQL & the EntityClient Provider in ADO.NET vNext and Orcas

  If you watch the ADO.NET team’s blog then you may have seen the post from today from Zlatko Michailov (Program Manager, ADO.NET). Here are the highlights from his post : In this Entity SQL (eSQL) post he discusses: what Entity SQL is a brief example... Posted Feb 14 2007, 07:09 PM by John Papa with | with no comments Filed under: .NET, SQL, ADO.NET, EF & LINQ

• 51st MSDN Magazine article! - Where has the time gone?

  So I am a bit late realizing that my 50th article was published in MSDN Magazine (including its predecessors MIND [Microsoft Internet Developer] and MIND [Microsoft Interactive Developer]) last month. The article was titled Revisiting System.Transactions... Posted Nov 20 2006, 10:32 AM by John Papa with | with 5 comment(s) Filed under: .NET, SQL, ADO.NET, Mobile Dev

• System.Transactions Revisited 2 Years Later

  The System.Transactions namespace of the Microsoft .NET Framework makes handling transactions much simpler than previous techniques. Posted Oct 15 2006, 04:32 PM by John Papa with | with 1 comment(s) Filed under: .NET, SQL, ADO.NET

• Accessing .NET Code from SQL Server Reporting Services' Reports

  The July 2007 issue of MSDN Magazine is now posted online. My latest Data Points column discusses how to create charts, embedded code, and access existing .NET class libraries from SQL Server Reporting Services 2005’s reports. You can read the article... Posted Jun 13 2006, 11:00 PM by John Papa with | with 1 comment(s) Filed under: .NET, SQL

• SQL Server 2005 Everywhere Edition CTP

  As of a few days ago, the SQL Server 2005 Everywhere Edition CTP is avaialble for download. This is the successor to SQL Server CE (aren’t name changes great). You can grab it here . if you want some documentation, you can download the SQL Server... Posted Jun 12 2006, 11:18 AM by John Papa with | with 1 comment(s) Filed under: SQL

• T Minus 3 hours: WebCast Using System.Transactions in .NET 2.0

  As I mentioned late last week , I'll be presenting Using System.Transactions in .NET 2.0 in on of the MSDN WebCast events later today (9:00am Pacific Time or 12:00 noon for us on the East Coast). I have several demonstations and slides but I will try... Posted May 31 2006, 09:00 AM by John Papa with | with 1 comment(s) Filed under: .NET, ADO.NET, SQL

• Join me for the System.Transactions in .NET 2 MSDN WebCast

  If you are interested in System.Transactions, I'll be doing a MSDN WebCast next week on Using System.Transactions in .NET 2.0 . The WebCast is on May 31st, at 9:00am Pacific Time. (That's 12 noon for us on the East Coast). Here is a brief summary of the... Posted May 27 2006, 01:27 PM by John Papa with | with 2 comment(s) Filed under: .NET, ADO.NET, SQL

• SQL Server 2005: T-SQL and XML Samples

  I've been asked for some T-SQL and XML code samples that I have presented of late. Here are some sample snippets of code that you can use to examine some of the SQL 2005 T-SQL features and its XML features, as well. The code is in a zip file below this... Posted May 18 2006, 01:28 PM by John Papa with | with 3 comment(s) Filed under: SQL

• Developing with SQL Server 2005 - XML Code Samples

  As promised here are the main code samples I demonstrated last week at the Toronto VSLive! conference for the Developing with SQL Server 2005 (XML Features) session. I will also post the code for the SQL Server 2005 and XML session here . Topics include... Posted Apr 30 2006, 09:27 PM by John Papa with | with 1 comment(s) Filed under: .NET, SQL