Showing posts with label ADO. Show all posts
Showing posts with label ADO. Show all posts

Monday, March 12, 2012

Using SQL Server Authentication (i.e. not Integrated/Trusted)? Concerned about your passwords being discoverable? Wish you could using something like SecureString?Check out the new SqlCredential in .Net 4.5

ADO.NET team blog - Safer passwords with SqlCredential

Introduction

Many users of SqlClient with SQL Server Authentication have expressed interest in setting credentials outside of the connection string to mitigate the memory dump vulnerability of keeping the User Name and Password in the connection string. Starting with .Net Framework 4.5, we have introduced the ability to set the credentials outside of the connection string via the new SqlCredential Credential property of SqlConnection. Now the developer can create a SqlCredential object with a UserId and a SecureString Password to hold the credential values of a connection when connecting to a server. This helps mitigate the threat of credentials being leaked out to the page file in a page swap or being evident in a crash dump.

image

SqlCredential Class

More information about the new SqlCredential class can be found at:
http://msdn.microsoft.com/en-us/library/system.data.sqlclient.SqlCredential(v=vs.110).aspx

For information on how to get or set the SqlConnection.Credential property, please refer to:
http://msdn.microsoft.com/en-us/library/system.data.sqlclient.sqlconnection.credential(v=vs.110).aspx

It’s important to note that the SqlCredential constructor only allows SecureString marked as read only to be passed in as the Password parameter or it will raise an ArgumentException. The new credential property is incompatible with existing UserId, Password, Context Connection=True, and Integrated Security=True connection string keywords, and setting the credential property on an open connection is not allowed. It is strongly recommended that you set PersistSecurityInfo=False (default) so the credential property is not returned as part of the connection once it is opened.

Connection Pooling with Credential Property

With this new improvement now the connection pooling algorithm also takes the Credential property into consideration in addition to the connection string property when creating connection pools and getting connections from the pool. Connections with the same connection string and same instance of Credential property will use the same connection pool, but connections with different instances of the Credential property will use different connection pools, even if they use the same UserId and Password. For example, the developer tries to open several connections with different configurations as below:

...

Of course the usage of SQL Server Integrated Authentication Mode is still the recommended way to authenticate for users with an Active Directory® infrastructure as there is no credential propagation and all security sensitive information is stored in the Active Directory’s database. And the usage of SQL Server Mixed Mode Authentication with UserId and Password specified in the connection string remains unchanged.

..."

This is one of those thing that would so easily fall through the cracks with all the recent news and releases, so I wanted to call it out. If you have to use Standard security in your SQL Server apps then when you move to .Net 4.5, take this extra step to secure your users passwords. At first glance it looks pretty painless yet could have a nice security bang for the buck...

Friday, December 30, 2011

Visual Studio 2010 and .NET Framework 4 Training Kit December 2011 Release (Think "MVC3 VB and OData HOL Love" version)

Microsoft Downloads - Visual Studio 2010 and .NET Framework 4 Training Kit December 2011 Release

Version: 2.2
Date Published: 12/30/2011

Language: English

VS2010TrainingKitDecember2011.Setup.exe, 497.7 MB

The Visual Studio 2010 and .NET Framework 4 Training Kit includes presentations, hands-on labs, and demos. This content is designed to help you learn how to utilize the Visual Studio 2010 features and a variety of framework technologies including:

  • C# 4
  • Visual Basic 10
  • F#
  • Parallel Extensions
  • Windows Communication Foundation
  • Windows Workflow
  • Windows Presentation Foundation
  • Silverlight 4
  • ASP.NET 4
  • Windows 7
  • Entity Framework
  • ADO.NET Data Services
  • Managed Extensibility Framework
  • Application Lifecycle Management
  • Windows Azure
This version of the Training Kit works with Visual Studio 2010 and .NET Framework 4.

..."

Updates in this release;

  • [New] Visual Basic versions of all MVC3 hands on labs
  • [New] Building Applications and Services Using Open Data Protocol hands-on lab
  • [Removed] Introduction to ADO.NET Data Services hands-on lab 

SNAGHTML1ddb4bfa

And a full span of the page;

image

And my usual WinDirStat snap (showing the VB love in the Kit :)

SNAGHTML1de412b2

 

Related Past Post XRef:
June 2011 release of the Visual Studio 2010 and .NET Framework 4 Training Kit (aka v2.0... or double the download size from the Feb 2010 release, or now 1.8GB of offline training, labs, information, goodness)
Visual Studio 2010 and .NET Framework 4 Training Kit – February Release (aka the VS2010 RC Compatible release) – We’re talking 602MB of VS/.Net training stuff here…
Visual Studio 2010 and .NET Framework 4 Training Kit - October Preview (aka VS2010 B2 version) released
A little VS2010/.Net 4 Training Kit with your Beta 1?

Thursday, June 30, 2011

June 2011 release of the Visual Studio 2010 and .NET Framework 4 Training Kit (aka v2.0... or double the download size from the Feb 2010 release, or now 1.8GB of offline training, labs, information, goodness)

Microsoft Downloads - Visual Studio 2010 and .NET Framework 4 Training Kit June 2011 Release

"Quick details

Version:  2.0
Date Published: 6/28/2011
Language: English

File Name:  VS2010TrainingKitJune2011.Setup.exe
Size: 421.0 MB

Overview

The Visual Studio 2010 and .NET Framework 4 Training Kit includes presentations, hands-on labs, and demos. This content is designed to help you learn how to utilize the Visual Studio 2010 features and a variety of framework technologies including:

  • C# 4
  • Visual Basic 10
  • F#
  • Parallel Extensions
  • Windows Communication Foundation
  • Windows Workflow
  • Windows Presentation Foundation
  • Silverlight 4
  • ASP.NET 4
  • Windows 7
  • Entity Framework
  • ADO.NET Data Services
  • Managed Extensibility Framework
  • Application Lifecycle Management
  • Windows Azure

This version of the Training Kit works with Visual Studio 2010 and .NET Framework 4.

..."

The last time I blogged about this training kit, Visual Studio 2010 and .NET Framework 4 Training Kit – February Release (aka the VS2010 RC Compatible release) – We’re talking 602MB of VS/.Net training stuff here…, the download size was 193MB, 602MB uncompressed. Now the download size is 423MB and 1.8GB uncompressed (wow, 3x's)

In short, if you're looking to learn about anything in the above list, this is a must download/use resource.

<whine> I really wish there was an easy to find "what's new" page/list/information/etc. It would really help those of us who get every release to know what's, well, new...</whine>

Here's a snap of the landing page;

image

And a monster pic/overview of all the items;

image

Finally a WinDirStat image of the install (looks like lots of databases/MDF's doesn't it?);

image

 

Related Past Post XRef:
Visual Studio 2010 and .NET Framework 4 Training Kit – February Release (aka the VS2010 RC Compatible release) – We’re talking 602MB of VS/.Net training stuff here…
Visual Studio 2010 and .NET Framework 4 Training Kit - October Preview (aka VS2010 B2 version) released
A little VS2010/.Net 4 Training Kit with your Beta 1?

Monday, January 24, 2011

The Entity Framework DZone Refcard

DZone RefCardz - ADO.NET Entity Framework

“The ADO.NET Entity Framework is a powerful object-relational mapping tool that exists inside Microsoft Visual Studio 2010. This DZone Refcard starts with the basics by showing you how to create a new Data Model. Once you have finished creating the Data Model, author Dane Morgridge moves on to discuss how to insert, query, update, and delete entities. Finishing things up is a section on POCO support with Entity Framework 4.0.

…”

5 1/2 Pages of Entity Framework cheatsheet will wake you up on a Monday morning… ;)

This sheet starts with the basics and then touches on the new capabilities in .Net/EF 4 and coming soon, such as POCO support in EF4 and Code First that’s coming soon (in CTP now)

Here’s a snap of the PDF;

image

Monday, November 01, 2010

ADO Guidance Map, the link-o-licious PDF

J.D. Meier's Blog - ADO.NET Developer Guidance Map

“If you’re interested in Microsoft data access (ADO.NET, Entity Framework, etc.), this map is for you.   Microsoft has an extensive collection of developer guidance available in the form of Code Samples, How Tos, Videos, and Training.  The challenge is -- how do you find all of the various content collections? … and part of that challenge is knowing *exactly* where to look.  This is where the map comes in.  It helps you find your way around the online jungle and gives you short-cuts to the treasure troves of available content.

The Windows ADO.NET Developer Guidance Map helps you kill a few birds with one stone:

  1. It show you the key sources of data access content and where to look (“teach you how to fish”)
  2. It gives you an index of the main content collections (Code Samples, How Tos, Videos, and Training)
  3. You can also use the map as a model for creating your own map of developer guidance.

Contents at a Glance

  • Introduction
  • Sources of Data Access Developer Guidance
  • Topics and Features Map (a “Lens” for Finding ADO.NET Content)
  • Summary Table of Topics
  • How The Map is Organized (Organizing the “Content Collections”)
  • Getting Started
  • Architecture and Design
  • Code Samples
  • How Tos
  • Videos
  • Training

image…”

Now that’s allot of links… ;)

Needs a HTML5 (or… cough… Silverlight… cough) front end. Better yet, an OData feed where we can plop our own pretty UI on… :)

Also check out;

 

Related Past Post XRef:
Hubs, Maps and Scenarios [Oh my] - New Microsoft Developer Guidance Maps from the Microsoft Connect Innovation Center

Tuesday, June 08, 2010

Need just some parts and pieces of the SQL Server 2008 R2? Like SMO, the Native Client, Report Builder v3, the SQL CLR Types, JDBC/PHP/DB2 Driver, etc, etc? Then you need the “Microsoft® SQL Server® 2008 R2 Feature Pack”

Microsoft Downloads - Microsoft® SQL Server® 2008 R2 Feature Pack

“The Microsoft® SQL Server® 2008 R2 Feature Pack is a collection of stand-alone packages which provide additional value for Microsoft® SQL Server® 2008 R2.

File Name: SQL Server 2008 R2 Feature Pack.htm
Version: 10.50.1600.1
Date Published: 6/7/2010
Language: English
Download Size: 1 KB - 394.9 MB*


The Microsoft® SQL Server® 2008 R2 Feature Pack is a collection of stand-alone packages which provide additional value for Microsoft® SQL Server® 2008 R2. It includes the latest versions of:

  • Redistributable components for Microsoft® SQL Server® 2008 R2.
  • Add-on providers for Microsoft® SQL Server® 2008 R2.

…”

Included in the SQL Server 2008 R2 Feature Pack are download links to;

  • Microsoft® SQL Server Report Builder 3.0 for Microsoft® SQL Server 2008 R2
  • Microsoft® SQL Server® PowerPivot for Microsoft® Excel
  • Microsoft® SQL Server® 2008 R2 Reporting Services Add-in for Microsoft® SharePoint® Technologies 2010
  • Microsoft® SQL Server® 2008 Reporting Services Add-in for Microsoft® SharePoint® Technologies 2007
  • Microsoft® SQL Server® 2008 R2 Policies
  • Microsoft® Sync Framework 2.0 Software Development Kit (SDK)
  • Microsoft® SQL Server® Compact 3.5 SP2
  • Microsoft® SQL Server® Compact 3.5 SP2 For Windows Mobile
  • Microsoft® SQL Server ®Compact 3.5 SP2 Server Tools
  • Microsoft® SQL Server® Compact 3.5 SP2 Books On-line
  • Microsoft® SQL Server® JDBC Driver 3.0
  • Microsoft® Connector 1.1 for SAP BW for SQL Server® 2008 R2
  • Microsoft® System CLR Types for SQL Server® 2008 R2
  • Microsoft® SQL Server® 2008 R2 Remote Blob Store
  • Microsoft® SQL Server® 2008 R2 Books On-line
  • Microsoft® SQL Server® 2008 R2 Upgrade Advisor
  • Microsoft® SQL Server® 2008 R2 Native Client
  • Microsoft® Core XML Services (MSXML) 6.0 SP 1
  • Microsoft® OLEDB Provider for DB2
  • Microsoft® SQL Server® 2008 R2 Command Line Utilities
  • Microsoft® SQL Server® Service Broker External Activator for SQL Server® 2008 R2
  • Microsoft® Windows PowerShell Extensions for SQL Server® 2008 R2
  • Microsoft® SQL Server® 2008 R2 Shared Management Objects
  • Microsoft® SQL Server® 2008 R2 ADOMD.NET
  • Microsoft® Analysis Services OLE DB Provider for Microsoft® SQL Server® 2008 R2
  • Microsoft® SQL Server® 2008 R2 Analysis Management Objects
  • Microsoft® SQL Server® 2008 Data Mining Add-ins for Microsoft® Office 2007
  • Microsoft® Datamining Viewer Controls For Microsoft® SQL Server® 2008
  • Microsoft® SQL Server® Driver for PHP 1.1
  • Microsoft® SQL Server® Migration Assistant
  • Microsoft® SQL Server® 2008 R2 Best Practices Analyzer

 

Related Past Post XRef:
SQL Server 2008 Feature Pack, August 2008 (i.e. The SQL2K8 RTM Feature Pack)

Friday, May 07, 2010

ADO.Net Data Services Update for .Net 3.5 SP1 - With added Feed customization, Office/SharePoint 2010 integration, enhanced blob and more (Think “ADO.Net Data Services .Net 3.5 SP1+++”)

ADO.NET Data Services Update for .NET Framework 3.5 SP1 for Windows Server 2003, Windows XP, Windows Vista and Windows Server 2008 or ADO.NET Data Services Update for .NET Framework 3.5 SP1 for Windows 7 and Windows Server 2008 R2

“The ADO.NET Data Services framework consists of patterns and libraries that enable the creation and consumption of REST-based data services for the web. This update to the Microsoft .NET Framework 3.5 SP1 provides additional features which extend the functionality provided in version 1.0 of the ADO.NET Data Services framework

Version: 3.5
Knowledge Base (KB) Articles: KB982307 & KB982306
Date Published: 5/6/2010
Language: English
Download Size: 1.7 MB - 10.8 MB*


The ADO.NET Data Services framework consists of patterns and libraries that enable the creation and consumption of REST-based data services for the web. This update to the Microsoft .NET Framework 3.5 SP1 provides additional features which extend the functionality provided in version 1.0 of the ADO.NET Data Services framework.
The ADO.NET Data Services Update for .NET Framework 3.5 SP1 provides the following new features and improvements:

  • Built-in integration in Microsoft Office 2010 now makes it simple to expose Microsoft Office SharePoint Server data as a data service and access that data using the ADO.NET Data Services client library.
  • Custom Data Service Provider support now makes it easier to build an ADO.NET Data Service over any data source.
  • A new DataServiceCollection class has been added that supports rich two-way data binding. The new collection implements automatic change tracking on client side objects created using the ADO.NET Data Services client library.
  • Feed customization, provides a rich and flexible way to shape and modify the structure of ATOM feeds produced by an ADO.NET Data Service. Modifying the structure of the ATOM feed produced by the ADO.NET Data Services makes it possible for third-party clients that can consume an ATOM feed in a custom format to consume feeds from an ADO.NET Data Service.
  • Enhanced blob support for streaming large binary objects to/from a data service. Support has also been added to the ADO.NET Data Services client library to provide the ability to upload and download binary objects (such as: images, videos, documents, etc.) from an application created using the library.
  • Server-driven paging allows a service author to limit the size of the result set returned by a query; this gives the service author a new level of control over the network bandwidth and computation time required to process any request.
  • A new select query option allows the result of a query to be projected into an arbitrary type; projecting gives the client the ability to request a specific set of properties of an entity. Reducing the number of properties requested in a query reduces processing time and network bandwidth for the request.
  • The option to request a count of the number of entities in a set and the option to include the total count of the number of entities in the set when a query returns a partial result.
  • Request pipeline improvements give the service author greater control and customization ability over various stages of query processing.

…”

There’s a number of cool items here for .Net 3.5er’s

Wednesday, April 21, 2010

The Microsoft Patterns & Practices Catalog Cheat Sheet

J.D. Meier's Blog - patterns & practices Catalog at a Glance

“Periodically I create a simple summary table of our patterns & practices collection of assets.  This helps me analyze the collection as a catalog.  To keep it incredibly simple, I organize the catalog by guidance types.  This way, at a glance, I can see the collections of guides, patterns, factories, reference implementations, and EntLib.  In this case, I also added any work in progress that I was aware of to get a real bird’s-eye view of the catalog.

image

…”

In short, don’t reinvent the wheel if you don’t have to…

 

Related Past Post XRef:
[There’s just to many to reference, I’ve blogged about many/most of these in the past, please search or check the appropriate tags on the right of the blog… thanks :]

Microsoft Enterprise Library 5.0 and Unity 2.0 RTW (& EntLib 3.x, 4.x to 5.0, Unity 1.x to 2 Migration Guide)

Grigori Melnik: Thoughts on Agile Software Engineering and Beyond - Microsoft Enterprise Library 5.0 Released!

“Last Friday I signed off on the last quality gates!  Yesterday we had our Release Readiness Meeting, which gave a resounding GO to the Enterprise Library 5.0 and a round of applause to the team. As one of the directors concluded “It is a beautiful thing… Not just the product, but also how you’ve got there.”

And now… a drum roll, please. On behalf of the patterns & practices Enterprise Library team I am very excited to announce the world-wide availability of Microsoft Enterprise Library 5.0.

What is Enterprise Library ?

Enterprise Library is a collection of reusable software components (application blocks) designed to assist software developers with common enterprise development challenges (such as logging, validation, caching, exception handling, and many others). Application blocks encapsulate Microsoft recommended development practices; they are provided as source code plus tests and documentation that can be used "as is," extended, or modified.

image

…”

Microsoft Downloads - Microsoft Enterprise Library 5.0

“Microsoft Enterprise Library is a collection of reusable application blocks designed to assist software developers with common enterprise development challenges. This release includes: Caching Block, Cryptography Block, Data Access Block, Exception Handling Block, Logging Block, Policy Injection Block, Security Block, Validation Block, and Unity.

Version: 5.0
Date Published: 4/20/2010
Language: English
Download Size: 5.3 MB - 16.4 MB*

This major release of Enterprise Library contains many compelling new features and updates that will make developers more productive. These include:

  • Major architectural refactoring that provides improved testability and maintainability through full support of the dependency injection style of development
  • Dependency injection container independence (Unity ships with Enterprise Library, but you can replace it with a container of your choice)
  • Programmatic configuration support, including a fluent configuration interface and an XSD schema to enable IntelliSense
  • Redesign of the configuration tool to provide:
    • A more usable and intuitive look and feel
    • Extensibility improvements through meta-data driven configuration visualizations that replace the requirement to write design time code
    • A wizard framework that can help to simplify complex configuration tasks
  • Data accessors for more intuitive processing of data query results
  • Asynchronous data access support
  • Honoring validation attributes between Validation Application Block and DataAnnotations
  • Integration with Windows Presentation Foundation (WPF) validation mechanisms
  • Support for complex configuration scenarios, including additive merge from multiple configuration sources and hierarchical merge
  • Optimized cache scavenging
  • Better performance when logging
  • A reduction of the number of assemblies
  • Support for the .NET 4.0 Framework and integration with Microsoft Visual Studio 2010
  • Improvements to Unity

…”

Microsoft Downloads - Microsoft Enterprise Library 5.0 Migration Guide

“…

Version: 5.0
Date Published: 4/20/2010
Language: English
Download Size: 649 KB - 1.3 MB*


This guide explains the opportunities open to you for migrating applications built using Enterprise Library versions 3.1, 4.0, and 4.1, and versions 1.0 and 1.1 of Unity to use version 5.0 or Enterprise Library and version 2.0 of Unity.

Because individual application scenarios and environments vary, and the way Enterprise Library and Unity are used within existing applications will differ considerably, this guide cannot guarantee success in every situation. However, it contains practical guidance that is based on knowledge gathered during the development of Enterprise Library 5.0, and through test migrations of a range of different existing applications.
…”

It’s like a RTM/RTW kind of month…

 

Related Past Post XRef:
Enterprise Library 4.0 RTW (May 2008)
Unity 1.0, Microsoft's Dependency Injection, Inversion of Control (DI/IOC) Container, has RTW'ed
Enterprise Library 3.0 - April 2007 Released
Enterprise Library for .NET Framework 2.0 RTM (January 2006)
Enterprise Library MSN Messenger Log Listener
"Avanade Integration Pack for Microsoft Enterprise Library Released"
Enterprise Library Logging : Rolling Flat File Sink
Microsoft Enterprise Library Tutorials
Microsoft Enterprise Library WebCasts
Download details: Enterprise Library
Enterprise Library (New release of the patterns & practices Application Blocks)

Thursday, April 15, 2010

Changing your target to .Net 4 – What’s changed from .Net 3.5 SP1 and what you can do about it as you move to .Net 4

ISV Developer Community - How to Migrate Your .NET 3.5 App to .NET 4

“Your .NET Framework 3.5 installs side-by-side with .NET Framework 4. So your application will work as expected when your customer installs .NET 4. But when you take your current code from .NET 3.5 and recompile it and target your application for .NET 4 in Visual Studio 2010, you may find some breaking changes.

Migration issues between the .NET Framework version 3.5 Service Pack 1 and the .NET Framework version 4, including fixes, changes for standards compliance and security, and changes based on customer feedback. Most of these changes do not require any programming modifications in your applications. The table provides steps that for you to take too

…”

What's New in the .NET Framework 4 - .NET Framework 4 Migration Issues

“This topic describes migration issues between the .NET Framework version 3.5 Service Pack 1 and the .NET Framework version 4, including fixes, changes for standards compliance and security, and changes based on customer feedback. Most of these changes do not require any programming modifications in your applications. For those that may involve modifications, see the Recommended changes column of the table.

This topic describes notable changes in the following areas:

  • ASP.NET

  • Core

  • Data (ADO.NET)

  • Windows Communication Foundation (WCF)

  • Windows Presentation Foundation (WPF)

  • XML

For information about new features, see What's New in the .NET Framework 4.

image

…”

With the RTM of .Net 4 many developers will start really looking at moving/upgrading their app’s. While there’s many years of life yet in CLR 2 (.Net 2/3/3.5), the goodness that’s in .Net 4 is very appealing and will help us solve a number of our users problems and to make their app lives better.

But it’s an UPGRADE, a migration, a move to a newer CLR. There will be bumps. The more we know about those bumps the faster and easier the migration will be…

Thursday, February 11, 2010

Visual Studio 2010 and .NET Framework 4 Training Kit – February Release (aka the VS2010 RC Compatible release) – We’re talking 602MB of VS/.Net training stuff here…

Microsoft Downloads - Visual Studio 2010 and .NET Framework 4 Training Kit - February Release

“February Release of the Visual Studio 2010 and .NET Framework 4 Training Kit

File Name: VS2010TrainingKitFebruarySetup.exe
Version: 1.3
Date Published: 2/10/2010
Language: English
Download Size: 199.4 MB


Overview

The Visual Studio 2010 and .NET Framework 4 Training Kit includes presentations, hands-on labs, and demos. This content is designed to help you learn how to utilize the Visual Studio 2010 features and a variety of framework technologies including:

  • C# 4.0
  • Visual Basic 10
  • F#
  • Parallel Extensions
  • Windows Communication Foundation
  • Windows Workflow
  • Windows Presentation Foundation
  • ASP.NET 4
  • Windows 7
  • Entity Framework
  • ADO.NET Data Services
  • Managed Extensibility Framework
  • Visual Studio Team System
This version of the Training Kit works with Visual Studio 2010 RC and .NET Framework 4 RC. [GD: Emphasis Added] 

…”

Holly cow… The download size has grown by 106MB since v1.1. From a compressed 93MB in v1.1 to a compressed 199MB (602MB uncompressed!) in this version. Wow

For a view of the v1.1 and v1.0 check out Visual Studio 2010 and .NET Framework 4 Training Kit - October Preview (aka VS2010 B2 version) released  & A little VS2010/.Net 4 Training Kit with your Beta 1?

 

Here’s a snap from the main page;

image

And a snap, via WinDirStat, of the contents. The 602MB isn’t just a ton of videos (there’s actually no “videos” on disk, they are all being hosted and streamed from Channel 9 is seems) but instead just tons of data, doc’s, resources and code.

image

 

Related Past Post XRef:
Visual Studio 2010 and .NET Framework 4 Training Kit - October Preview (aka VS2010 B2 version) released
A little VS2010/.Net 4 Training Kit with your Beta 1?

Visual Studio 2010 Licensing White Paper (includes Team Foundation Server, Lab Management and IntelliTrace)
VS 2010 RC now available for download to the general public (no MSDN Subscription required)
VS2010 RC now available on MSDN Subscribers Download. General availably coming tomorrow (February 10th)
VS2010/.Net 4 release date slips and we get a public RC in February to make up for it (and I’m okay with it)

Visual Studio 2010/.Net 4.0 B2 now available via MSDN Subscribers Download, new SKU names (Ultimate, Premium, Express Combo) and VS2010 launch dates announced
VSTS/TFS2010 Beta 2 coming “real soon” and will have a “Go Live” license (i.e. Now’s the time to start getting ready…)

Tuesday, January 12, 2010

Free Developer Training for Visual Studio 2010, .NET 4 – On Demand from msDev

US ISV Developer Community - Free Developer Training for Visual Studio 2010, .NET 4

“ A new series of on-demand videos covers some of the new features in Visual Studio 2010, as of the Beta 2 release, and some of the new language features in .NET languages including C#, Visual Basic.NET, and F#, as of version 4 of the .NET framework. The videos are available from MSDEV today.

Topics available today include:

  • Parallelism
  • ADO.Net Data Services
  • F#
  • Office Programmability

Topics available next week include:

  • ASP.NET AJAX
  • ASP.NET MVC
  • ASP.NET Web Forms
  • Managed Languages

To see the videos, see New Features in .NET Framework 4 and Visual Studio 2010, Beta 2.
…” [Post Leach level: 99%]

Nice thing about on demand sessions is that,well, you can view them on demand. ;)

Again I must say, the msdev site is a great resource and one that should be closely watched in the coming year…

 

Related Past Post XRef:
A Feed You Should Read #8 – msdev

“Everything You Need to Know About Azure as a Developer” 18 part course on msdev.com updated to include four new Windows Azure AppFabric sessions
How about 716, or so, free live and on-demand development training courses/web sessions? Then head on over to msdev.com…
An official “bunch” free of SQL Server 2008 R2 / SQL Server 2008 Express web sessions and how-to’s videos coming starting in September

Tuesday, January 05, 2010

Entity Framework links, links and more links - 100+ Delicious EF Links

Tony and Zuzana’s World - 100 EF4 Links

“As part of my DevelopMentor Entity Framework course, I put together a delicious web site containing over 100 links to Entity Framework 4.0 topics.

http://delicious.com/tonysneed_elinq

…” [Post Leach Level: 99%]

Delicious - tonysneed_elinq's Bookmarks

image

I’ve started playing with EF4 and so this list will come in handy…

Wednesday, December 16, 2009

ADO.NET Data Services Update for .NET Framework 3.5 SP1 now available

Microsoft Downloads - ADO.NET Data Services Update for .NET Framework 3.5 SP1 for Windows 7 and Windows Server 2008 R2 & ADO.NET Data Services Update for .NET Framework 3.5 SP1 for Windows 2000, Windows Server 2003, Windows XP, Windows Vista and Windows Server 2008

“The ADO.NET Data Services framework consists of patterns and libraries that enable the creation and consumption of REST-based data services for the web. This update to the Microsoft .NET Framework 3.5 SP1 provides additional features which extend the functionality provided in version 1.0 of the ADO.NET Data Services framework

The ADO.NET Data Services framework consists of patterns and libraries that enable the creation and consumption of REST-based data services for the web. This update to the Microsoft .NET Framework 3.5 SP1 provides additional features which extend the functionality provided in version 1.0 of the ADO.NET Data Services framework.

The ADO.NET Data Services Update for .NET Framework 3.5 SP1 provides the following new features and improvements:

  • Built-in integration in Microsoft Office 2010 now makes it simple to expose Microsoft Office SharePoint Server data as a data service and access that data using the ADO.NET Data Services client library.
  • Custom Data Service Provider support now makes it easier to build an ADO.NET Data Service over any data source.
  • A new DataServiceCollection class has been added that supports rich two-way data binding. The new collection implements automatic change tracking on client side objects created using the ADO.NET Data Services client library.
  • Feed customization, provides a rich and flexible way to shape and modify the structure of ATOM feeds produced by an ADO.NET Data Service. Modifying the structure of the ATOM feed produced by the ADO.NET Data Services makes it possible for third-party clients that can consume an ATOM feed in a custom format to consume feeds from an ADO.NET Data Service.
  • Enhanced blob support for streaming large binary objects to/from a data service. Support has also been added to the ADO.NET Data Services client library to provide the ability to upload and download binary objects (such as: images, videos, documents, etc.) from an application created using the library.
  • Server-driven paging allows a service author to limit the size of the result set returned by a query; this gives the service author a new level of control over the network bandwidth and computation time required to process any request.
  • A new select query option allows the result of a query to be projected into an arbitrary type; projecting gives the client the ability to request a specific set of properties of an entity. Reducing the number of properties requested in a query reduces processing time and network bandwidth for the request.
  • The option to request a count of the number of entities in a set and the option to include the total count of the number of entities in the set when a query returns a partial result.
  • Request pipeline improvements give the service author greater control and customization ability over various stages of query processing.

…” [GD: Description Leached in Full]

So kind of a ADO.Net Data Services 1.0 from .Net 3.5 SP1 R2? (Or I think this version is officially called ADO.Net Data Services 3.5?)

Haven’t seen any more news on this yet and the Knowledgebase articles (KB976127 & KB976126) are not live yet. I’m sure we’ll see more tomorrow but some of the changes sound interesting…

 

Update #1 12/17/2009 @ 9:10AM PST:
Here’s some additional information and details, ADO.NET Data Services Team Blog - Data Services Update for .NET 3.5 SP1 – Now Available for Download

“…

…This release targets the .NET Framework 3.5 SP1 platform, provides new client and server side features for data service developers and will enable a number of new integration scenarios such as programming against SharePoint Lists.     

As noted in the release plan update post, this release is a redistributable, in-place update to the data services assemblies (System.Data.Services.*.dll) which shipped as part of the .NET Framework 3.5 SP1.  Since this is a .NET Framework update, this release does not include an updated Silverlight client library, however, we are actively working on an updated Silverlight client to enable creating SL apps that take full advantage of the new server features shipped in this release.  We hope to have the updated SL client available shortly into the new year. 

image.”

Friday, November 20, 2009

A high level Data Guide for the Dev Guy - “Guide to the Data Development Platform for .NET Developers”

Bob Beauchemin's Blog - Guide to the Data Development Platform for .NET Developers whitepaper available

“I've been busy for the last few weeks putting together a "manifesto" whitepaper about the .NET-based data access stacks and also the possibilities for .NET programmers in the SQL Server product itself. The whitepaper's direct link is here, although its also available via both the MSDN Data Developer Center and the SQL Server 2008 Application Development website. I don't see the arbitrary distinction between application developers who use databases and SQL developers that some do, so writing this paper and covering both was a good fit.

This whitepaper is quite a bit more high-level than others that I've written, meant to be an all-embracing introduction to .NET and SQL Server and point out the possibilities for .NET programmer. While writing this I was stunned at how many integration points there are between .NET and SQL Server. Every part of the SQL Server product uses .NET in one form or another. Check it out.

…”

MSDN - Guide to the Data Development Platform for .NET Developers

“SQL Server Technical Article
(11 printed pages)

Writer: Bob Beauchemin, SQLskills

Published: November 2009

Applies to: SQL Server 2008

Summary: This whitepaper covers all facets of the .NET data development platform. This includes not only client-side and service-based APIs but also .NET APIs for programming at a server level inside the SQL Server 2008 database and for developing and testing a SQL Server database application. It also includes information on future directions of the .NET and SQL Server development platform.

Guide to the Data Development Platform for NET Developers

With all the Microsoft data access means and methods sometimes we need to take a step back and take a higher level look at things. That’s what I liked about this whitepaper, the 30,000 foot view it provided.

Monday, April 20, 2009

UK MSDN Flash – Best of 2008 #1 in eBook form

IUpdateable from Eric Nelson - FREE MSDN Flash eBook with 13 technical articles spanning dynamic languages to game development to cloud computing

“…

Every two weeks we send an email out to tens of thousands of UK based developers. This email is called the MSDN Flash. The Flash contains many useful sections including a 400 to 500 word technical article on a developer related topic either written by a member of the Microsoft UK technical team or a member of the broader UK developer community. We have had some great articles over the years which to some extent end up “hidden away” in the archives of the MSDN Flash. This is a shame as the authors have worked hard to condense complex topics into short articles which are informative and take only a few minutes to read.

I decided it was time to surface the best of the articles on a regular basis and provide them in an easy to download and read eBook. This initial edition covers the period January 2008 to January 2009 but we aim to create a new eBook every six months from here on in. The next edition should therefore be out around August 2009.

image 

Table of Contents for #1

TABLE OF CONTENTS 2
INTRODUCTION 4
From the Editor 4
Would you like to become an author? 5
Subscribe to the UK MSDN Flash 5
VISUAL STUDIO 2008 7
Synchronization made Easy by the Sync Framework 7
WMI Provider Extensions in .NET Framework v3.5 8
Non-Attributed Data Contracts in WCF 9
Introducing the ADO.NET Entity Framework 10
Introducing the .NET Client Profile 11
XNA Game Studio 12
LANGUAGES 13
Combining Dynamic Languages and Static Languages 13
Getting Started with IronPython 14
TOOLS AND DEVELOPMENT PRACTICES 15
Pex: Automated testing for .NET 15
WEB 16
The Integrated Pipeline in IIS7 16
VISUAL STUDIO 2010 17
Introducing Parallel Extensions to the .NET Framework 17
CLOUD COMPUTING 18
Azure Services Platform 18
Windows Azure 19
MEET THE AUTHORS 20

image

While the page count isn’t huge, the information density seems pretty high. Short and sweet read for the train or bio break (did I REALLY just say that? :P  )

Tuesday, January 13, 2009

Firebird ADO.NET Provider (with source) for Entity Framework Beta Released

ADO.NET team blog - Beta of Firebird ADO.NET Provider with Entity Framework Support Available

“I'm pleased to announce that a beta of the Firebird ADO.NET provider with Entity Framework support is now available.  Congratulations to Jiří Činčura and to everyone else who has worked on this project so far!

For more information, please see Jiří's blog post here or access the download page for the provider here.

…” [Post leached level: 99%]

Jiří {x2} Činčura - Firebird ADO.NET Data Provider 2.5.0 Beta 1 for .NET 3.5/2.0 [with Entity Framework support]

“I'm pleased to announce 2.5.0 Beta 1 for .NET 3.5/2.0 [with Entity Framework support] version. It contains several bugfixes as well as brand new Entity Framework support (still beta!). Looking forward to your feedback.

Binary as well as sources can be downloaded from http://www.firebirdsql.org/index.php?op=files&id=netprovider.” [Post leached in full]

Firebird - Firebird .Net Providers Downloads

image

It’s been a few years since I’ve posted about Firebird, so after seeing this I felt it was time…

 

Related Past Post XRef:
Enterprise Library Data Provider for Firebird
DotNetFirebird - Using Firebird SQL in .NET
MS SQL Server to FireBird migration

Monday, September 22, 2008

SQLite for ADO.Net 1.0.59.0 Released

ADO.NET 2.0 Provider for SQLite - 1.0.59.0

“Code merge with SQLite 3.6.3. Solves a couple different EF issues that were either giving inconsistent results or crashing the engine. Fixed the parsing of literal binaries in the EF SqlGen code. SQLite now passes nearly all the testcases in Microsoft's EF Query Samples application -- the exception being the datetimeoffset and time constants tests, and tests that use the APPLY keyword which are unsupported for now. Revamped the Compact Framework mixed-mode assembly. Tired of playing cat and mouse with the Compact Framework's support for mixed-mode assemblies. The CF build now requires that you distribute both the System.Data.SQLite library and the paired SQLite.Interop.XXX library. The XXX denotes the build number of the library. Implemented a workaround for Vista's overzealous caching by turning off FILE_FLAG_RANDOM_ACCESS for OS versions above XP. This is implemented as a custom (default override) VFS in the interop.c file, so no changes are made to the SQLite source code. Fixed some registry issues in the designer install.exe, which prevented some design-time stuff from working on the Compact Framework when .NET 3.5 was installed.

…”

System.Data.SQLite (An open source ADO.NET provider for the SQLite database engine)

System.Data.SQLite is the original SQLite database engine and a complete ADO.NET 2.0 provider all rolled into a single mixed mode assembly.  It is a complete drop-in replacement for the original sqlite3.dll (you can even rename it to sqlite3.dll).  Unlike normal mixed assemblies, it has no linker dependency on the .NET runtime so it can be distributed independently of .NET.

Here is a brief overview of its features:

Complete ADO.NET 2.0 Implementation
The provider was written from scratch on VS2005/2008 specifically for ADO.NET 2.0, using all the most recent changes to the ADO.NET framework.  That includes full DbProviderFactory support, automatic distributed transaction enlistment, connection pooling, extensive schema support, Entity Framework support and more.

Supports the Full and Compact .NET Framework as well as native C/C++
Whether you're programming in .NET or straight C/C++ on the desktop or a mobile device, we've got a build for you.

Mono support
A managed-only version of the provider is also available that works on Mono against the official SQLite library from http://www.sqlite.org/.  Requires 3.6.1 or higher.

Support for the ADO.NET 3.5 Entity Framework
SQLite's EF provider is still in beta for now, but go ahead and kick the tires!

…”

Google’s Chrome using SQLite has reignited my interest in this project making this ADO.Net provider for SQLite seem like a no-brainer place for me to start…

This is now a pretty active project, with releases coming quite often, so if you are interested, subscribe to the SourceForge release feed to keep up.

 

Related Past Post XRef:
Your Three Minute Guide to SQLite and .Net

Saturday, August 30, 2008

SQL Server SQLClient Timeouts 101 - Everything you’ve wanted to know about SQLClient Timeouts that can be covered in a few pages or less

Tone Poem - SqlClient Timeouts Revealed

“SqlClient.  First a classification of where timeouts can occur with SqlClient:

  1. When attempting to get a connection from the SqlClient connection pool
  2. When attempting to create a new fresh connection to server (not getting one from pool)
  3. When sending a command explicitly to the server
  4. When sending commands with "context connection=true"
  5. When sending commands implicitly (under the covers) to the server
  6. When executing asynchronous commands (BeginExecute...)
  7. When waiting for attention acknowledgement from server (special rare case)
  8. When sending TM commands
  9. When fetching rows
  10. When uploading rows using bulk copy

Login Timeouts

Explicit Command Execution Timeouts

SqlConnection and "context connection=true"

Implicit Command Timeouts

Asynchronous Command Execution Timeout

Cancel Timeout (attention acknowledgement timeout)

…”

How async command execution timeouts are handled (or not) was news to me. Learning more every day…

Wednesday, August 06, 2008

Sync Framework v1 RTM’s (and includes ADO.Net Sync Services v2)

Rob Tiffany's Windows Mobile Accelerator - Sync Framework v1 and Sync Services for ADO.NET v2 are now Generally Available!

“As of today you can download the Sync Framework SDK in 11 languages including Chinese (Hong Kong), Chinese (Simplified), English, German, French, Italian, Japanese, Korean, Portuguese, Russian and Spanish for AMD64, IA64 and x86 processors from the Sync Framework Download Center

What is Sync Framework?

Imagine being able to build a solution that seamlessly exchanges contact information between Outlook, a database contact management application, your mobile device and your service based contact management system.  Or how about a mobile device that connects with other devices to exchange pictures and videos.  How about being able to take data from any of your enterprise databases, file or enterprise systems and make it available offline for users to modify and sync back up to the enterprise.  All of these capabilities are possible with the Sync Framework and best of all, it is free on Windows platforms and licensable on non-Windows platforms!

…”

Microsoft Downloads - Microsoft Sync Framework v1.0

“Microsoft Sync Framework is a comprehensive synchronization platform for enabling collaboration and offline scenarios for applications, services and devices

Version: RTM1
Date Published: 8/5/2008
Language: English
Download Size: 1.1 MB - 504.3 MB*

Microsoft Sync Framework is a comprehensive synchronization platform that enables collaboration and offline scenarios for applications, services and devices. Developers can build sync ecosystems that integrate any application, any type of data, using any protocol over any network.
The Microsoft Sync Framework provides a platform for taking web services and databases offline. In addition, it provides optimized P2P sync of any type of file including contacts, music, videos, images and settings. The extensible framework includes built-in support for synchronizing databases, NTFS/FAT file systems, FeedSync compliant feeds (formerly known as Simple Sharing Extensions), devices and web services.

Sync Framework Highlights

  • Add sync support to new and existing applications, services, and devices
  • Enable collaboration and offline capabilities for any application
  • Roam and share information from any data store, over any protocol, and over any network configuration
  • Leverage sync capabilities exposed in Microsoft technologies to create sync ecosystems
  • Extend the architecture to support custom data types including files


Sync Services for ADO.NET
Sync Services for ADO.NET is a Microsoft Sync Framework powered solution for synchronizing ADO.NET enabled databases in offline and collaboration scenarios. Sync Services for ADO.NET allows developers who are familiar with the concepts of ADO.NET to apply that knowledge to data synchronization through a very similar set of APIs to that of ADO.NET. Sync Services for ADO.NET provides the flexibility of a programming model like offline datasets and a richer synchronization feature set like that found in Merge replication. Sync Services for ADO.NET also supports synchronization over services, such as Windows Communication Foundation (WCF).

Sync Services for ADO.NET Highlights

  • Offline Database Synchronization: With Sync Services for ADO.NET you are able to build a solution where multiple remote clients connect and synchronize to a central ADO.NET database in a Hub-and-Spoke configuration. This enables occasionally connected devices to periodically connect and synchronize changes with a central ADO.NET database server. This topology is a common solution for remote workers such as sales reps or field service workers.
  • Collaboration Between Databases: Sync Services for ADO.NET also includes Peer-to-Peer capabilities. Through a custom Peer provider, collaboration between two or more SQL Server databases can occur (support is not available for SQL Server Compact). Unlike a Hub-and-Spoke architecture, this provider enables a SQL Server database to communicate and exchange information with any other SQL Server database. This type of scenario is useful in group scenarios where users (such as auditors) need to update information and then collaborate those changes with other group members.
  • SQL Server 2008 Integrated Change Tracking: If you are using SQL Server 2008, we recommend that you use the SQL Server change tracking feature. This feature addresses many of the issues of custom-tracking systems and provides a straightforward way to track changes. Change tracking is also supported by the Local Database Cache in Visual Studio 2008 SP1. Developers can now specify that the Configure Data Synchronization wizard should enable SQL Server change tracking on the server and generate the commands necessary to select and apply changes to the server database. Unlike custom change tracking systems, SQL Server change tracking does not require any schema changes in the server database. For more information, see the Visual Studio 2008 documentation.

…” [Description leached in full]

Microsoft Sync Framework - Top New Features in Sync Services for ADO.NET v2

“Today’s release of Microsoft Sync Framework includes the latest version of Sync Services for ADO.NET.  A great deal of work has gone into this release and I thought I would take some time to point out some of the top new features in version 2 since our previous release.

  • Peer-to-peer synchronization support:

  • Sync Services is now based on Microsoft Sync Framework:

  • Synchronize with devices:

  • Support for SQL Server 2008 Integrated Change Tracking:

  • Support for the new data types in SQL Server 2008:

  • The ability to trace the synchronization process:

…”

Though referenced in the SQL Server 2008 Feature Pack, August 2008 post, I thought this one deserved its own shoutout…

 

Related Past Post XRef:
Using Microsoft Sync Framework in Visual Studio 2008 to Sync SQL Databases (SQL CE with SQL Server)
Microsoft Sync Framework CTP1 Released