{"id":2204,"date":"2012-09-12T17:52:00","date_gmt":"2012-09-12T17:52:00","guid":{"rendered":"https:\/\/blogs.msdn.microsoft.com\/webdev\/2012\/09\/12\/asp-net-data-access-guidance-published\/"},"modified":"2012-09-12T17:52:00","modified_gmt":"2012-09-12T17:52:00","slug":"asp-net-data-access-guidance-published","status":"publish","type":"post","link":"https:\/\/devblogs.microsoft.com\/dotnet\/asp-net-data-access-guidance-published\/","title":{"rendered":"ASP.NET Data Access Guidance Published"},"content":{"rendered":"<p>On 9\/11 we published a new* set of pages on MSDN offering guidance for getting started with data access in ASP.NET. If you&#8217;re already using ASP.NET, parts of these pages will just repeat what you already know or take for granted, but a few parts contain recommendations that are new for ASP.NET 4.5. These pages clearly identify which technologies are still available and supported but are no longer part of Microsoft&#8217;s strategic direction, such that you should think twice before choosing them if you&#8217;re creating something new. One page provides help setting up SQL Server connection strings.<\/p>\n<p>Here are links to the new pages, with a sampling of what you can find in them:<\/p>\n<ul>\n<li><a href=\"http:\/\/msdn.microsoft.com\/library\/6759sth4\" target=\"_blank\" rel=\"noopener\">ASP.NET Data Access Content Map<\/a>\n<ul>\n<li>Links to Internet resources for data access in ASP.NET, organized by subject.<\/li>\n<\/ul>\n<\/li>\n<li><a href=\"http:\/\/msdn.microsoft.com\/library\/ms178359\" target=\"_blank\" rel=\"noopener\">Choosing Data Access Options for ASP.NET Web Applications<\/a>\n<ul>\n<li>Choosing a DBMS (choose SQL Server).<\/li>\n<li>Choosing a SQL Server edition for development (choose LocalDB for VS 2012, SQL Server Express for VS 2010)<\/li>\n<li>Choosing an ORM (choose Entity Framework).<\/li>\n<li>Choosing an Entity Framework development workflow (Code First vs. Database First or Model First).<\/li>\n<li>LINQ vs. SQL (use LINQ wherever possible).<\/li>\n<li>Web Forms choices<\/li>\n<ul>\n<li>When to use ListView vs. Repeater vs. GridView controls.<\/li>\n<\/ul>\n<ul>\n<li>When to use DetailsView vs. FormView control.<\/li>\n<\/ul>\n<ul>\n<li>When to use TemplateField vs. BoundField vs. DynamicField controls.<\/li>\n<\/ul>\n<ul>\n<li>When to use the DynamicControl control.<\/li>\n<\/ul>\n<ul>\n<li>When to use data source controls vs. Web Forms model binding vs. manual data binding.<\/li>\n<\/ul>\n<ul>\n<li>When to use Eval and Bind vs. Item and BindItem data-binding expressions.<\/li>\n<\/ul>\n<ul>\n<li>Recommendation to use the new-in-4.5 data-binding expression delimiter (&lt;%#:) for HTML encoding.<\/li>\n<\/ul>\n<ul>\n<li>When to use Dynamic Data project templates.<\/li>\n<\/ul>\n<li>When to use Web API vs. WCF<\/li>\n<\/ul>\n<\/li>\n<li><a href=\"http:\/\/msdn.microsoft.com\/library\/jj653752\" target=\"_blank\" rel=\"noopener\">SQL Server Connection Strings for ASP.NET Web Applications<\/a>\n<ul>\n<li>Sample connection strings for LocalDB, SQL Server Express, SQL Server, SQL Database, and SQL Server Compact.<\/li>\n<li>How to convert a connection string from LocalDB to SQL Server Express and vice versa.<\/li>\n<li>How to configure Data Source, AttachDbFileName, Initial Catalog, Integrated Security, MultipleActiveResultSets, and User Instance settings.<\/li>\n<\/ul>\n<\/li>\n<li><a href=\"http:\/\/msdn.microsoft.com\/library\/ms247257.aspx\" target=\"_blank\" rel=\"noopener\">Using SQL Server Compact 4.0 for ASP.NET Web Applications<\/a>\n<ul>\n<li>SQL Server Compact&#8217;s status compared to other SQL Server editions.<\/li>\n<li>Sections on installing, deploying, tools, and migrating to SQL Server.<\/li>\n<\/ul>\n<\/li>\n<li><a href=\"http:\/\/msdn.microsoft.com\/library\/jj653753.aspx\" target=\"_blank\" rel=\"noopener\">ASP.NET Data Access FAQ<\/a>\n<ul>\n<li>When to use Microsoft Access in a web application (don&#8217;t).<\/li>\n<li>Is SQL Server Express OK to use in production (it is).<\/li>\n<li>Can you combine the membership database with your application database (yes).<\/li>\n<li>How to round-trip web projects with databases between Visual Studio 2010 and 2012 (install SQL Server Express 2008 in Visual Studio 2012).<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<p>*Some of these ASP.NET 4.5 pages existed in ASP.NET 4 or earlier versions, but the content is all new. The others are new pages for ASP.NET 4.5.<\/p>\n<p>Feedback is welcome, and this blog is the best place to post comments.<\/p>\n<p><b>&#8212; Tom Dykstra <\/b><\/p><\/p>\n","protected":false},"excerpt":{"rendered":"<p>On 9\/11 we published a new* set of pages on MSDN offering guidance for getting started with data access in ASP.NET. If you&#8217;re already using ASP.NET, parts of these pages will just repeat what you already know or take for granted, but a few parts contain recommendations that are new for ASP.NET 4.5. These pages [&hellip;]<\/p>\n","protected":false},"author":424,"featured_media":58792,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[197],"tags":[],"class_list":["post-2204","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-aspnet"],"acf":[],"blog_post_summary":"<p>On 9\/11 we published a new* set of pages on MSDN offering guidance for getting started with data access in ASP.NET. If you&#8217;re already using ASP.NET, parts of these pages will just repeat what you already know or take for granted, but a few parts contain recommendations that are new for ASP.NET 4.5. These pages [&hellip;]<\/p>\n","_links":{"self":[{"href":"https:\/\/devblogs.microsoft.com\/dotnet\/wp-json\/wp\/v2\/posts\/2204","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/devblogs.microsoft.com\/dotnet\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/devblogs.microsoft.com\/dotnet\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/dotnet\/wp-json\/wp\/v2\/users\/424"}],"replies":[{"embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/dotnet\/wp-json\/wp\/v2\/comments?post=2204"}],"version-history":[{"count":0,"href":"https:\/\/devblogs.microsoft.com\/dotnet\/wp-json\/wp\/v2\/posts\/2204\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/dotnet\/wp-json\/wp\/v2\/media\/58792"}],"wp:attachment":[{"href":"https:\/\/devblogs.microsoft.com\/dotnet\/wp-json\/wp\/v2\/media?parent=2204"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/dotnet\/wp-json\/wp\/v2\/categories?post=2204"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/dotnet\/wp-json\/wp\/v2\/tags?post=2204"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}