SQLSaturday in Tampa Florida Presentation - SQL Server Data Access Tips and Techniques

David Hayden will be presenting the following presentation at SQLSaturday in Tampa, Florida on Saturday, February 16th, 2008.

SQL Server Data Access Tips and Techniques

You have optimized and tuned your SQL Server Database and now you need to access the data from your application. Learn and explore the variety of ways you can access the data using ADO.NET, the Data Access Application Block, LINQ To SQL, ADO.NET Entity Framework, ADO.NET Data Services, and the ASP.NET 3.5 Dynamic Data Framework. In this session we will walk-thru and build several examples for each technique as well as discuss tips, strengths, and weaknesses. Come with your questions and explore the wonderful world of data access to SQL Server!

LINQ To SQL Tutorials

• ASP.NET Dynamic Data and Validation Using LINQ To SQL OnPropertyChanging Partial Methods
• LINQ To SQL LIKE Operator - Generating LIKE in SQL Server Statements
• Create a Custom Profile Provider in ASP.NET 2.0 Using LINQ To SQL For Kicks
• LINQ To SQL Enum Support Example Using Discriminator Column and Inheritance Mapping
• LINQ To SQL Discriminator Column Example - Inheritance Mapping Tutorial
• LINQ To SQL Attach Method for Attaching Detached Business Entities - DataContext.Attach
• LINQ To SQL and Visual Studio 2008 Performance Update
• LINQPad - Dynamically Query SQL Server Databases in LINQ
• LINQ To SQL Debugger Visualizer Revisited - Same Concerns Better UI :)
• DataContext.Log - Logging LINQ To SQL Output to Console or Debugger Output Window
• LINQ To SQL Debugger Visualizer in Visual Studio 2008 Has Limited Value - LINQ To SQL Tutorials
• LINQ To SQL As Replacement To Data Access Guidance Package
• LINQ Data Access Layer - Creating Insert Update Delete Stored Procedures
• Creating Data Access Layer Using LINQ To SQL - Stored Procedures Support
• LinqDataSource - High Performance Queries Using DataLoadOptions - Avoiding Database Roundtrips
• LINQ to SQL - Performance Tradeoffs: Less Database Roundtrips but Duplicated Data in Each Row??
• LINQ To SQL - Lazy Loading Properties and Specifying PreFetch When Needed - Sweet Query and Performance Control
• LINQ To SQL Video - Getting From Expression Trees to SQL

ASP.NET Dynamic Data Tutorials

• ASP.NET Dynamic Data - Displaying, Inserting and Editing Images in SQL Server Database
• ASP.NET Dynamic Data Tutorial - BuddyMetadataProvider and Custom Metadata Providers
• ASP.NET Dynamic Data Website Getting Started - ASP.NET RAD Development for Data-Driven Websites
• ASP.NET Dynamic Data Websites - Customizing Pages and Validation
• ASP.NET Dynamic Data and Validation Using LINQ To SQL OnPropertyChanging Partial Methods
• ASP.NET Dynamic Data Websites - Creating Custom Dynamic Data Fields

Data Access Application Block Tutorials

• Enterprise Library 2.0 DAAB and ADO.NET 2.0 Batch Updates Feature
• Data Access Application Block - Reduce ADO.NET Code in Your Applications
• Saving and Retrieving Images From SQL Server Using DAAB
• Enterprise Library 2.0 DAAB - Retrieving PK and Timestamp When Inserting New Record
• Enterprise Library 2.0 DAAB and Encrypting ConnectionStrings in App.Config
• Using Enterprise Library DAAB and Microsoft Access 2007 via ODBC and OLEDB - Connection Strings and ADO.NET
• Typed DataSets and Data Access Application Block ( DAAB ) - Enterprise Library Tutorials
• Reading Connection Strings in Web.Config and App.Config and Enterprise Library DAAB Settings
• DatabaseConfigurationView Class in Enterprise Library Data Access Application Block - Read Database Connection Strings and Configuration
• SqlCacheDependency using DAAB and SQL Server 2005 - Enterprise Library 2.0
• Data Access Application Block Supports SQL Server Compact Edition with SqlCeDatabase Class - Enterprise Library 3.0 Tutorials
• SqlCommandBuilder.DeriveParameters - Get Parameter Information for a Stored Procedure - ADO.NET Tutorials
• Creating Data Access Layer Using DbProviderFactories and DbProviderFactory
• TransactionScope and Enterprise Library 3.0 Data Access Application Block - System.Transactions

Topics

• Acceptance Test Engineering Guidance
• ASP.NET MVC Framework
• Enterprise Library
• Prism
• Repository Factory
• Smart Client Software Factory
• Unity
• Web Client Software Factory
• Web Service Software Factory

Popular Tags

• AcceptanceTestGuidance
• ADODataServices
• ADONET
• ADONETEntityFramework
• AJAX
• AltNetConf
• AOP
• ApplicationBlockSoftwareFactory
• AppSettings
• ArchitectureJournal
• ArchitectureJournalReader
• ArgumentValidationException
• AuthorizationRulesService
• AuthorizationService
• AutocompleteGuidanceBundle
• Autofac
• Caliburn
• CastleActiveRecord
• CastleWindsor
• CodeGeneration
• CompositeWebApplicationBlock
• CompositeWebClientAutomation
• ConfigurationSectionEncryption
• ContextAutoCompleteExtender
• DataAccessApplicationBlock
• DataAccessGuidancePackage
• DataAccessLayer
• DataContract
• DayOfPnP
• DependencyInjection
• DesignByContract
• DynamicData
• DynamicProxy
• EnterpriseLibrary
• EnterpriseLibrary4
• EntLibConfigurationEditor
• EnvironmentalOverrides
• F#
• Frameworks
• Gallio
• GAT
• GAX
• GuidanceBundles
• GuidanceExplorer
• IASA
• IControllerFactory
• IoC
• IronPython
• LinFu
• LINQ
• LinqToSql
• MembershipProvider
• MessageTemplateTokens
• ModelViewPresenter
• ModularityBundle
• ModuleInitializer
• Moq
• MVC
• MVPBundle
• NHibernate
• ObjectBuilder
• ObjectContainerDataSource
• OrlandoCodeCamp
• PageFlowApplicationBlock
• PartialClasses
• PassiveView
• PerformanceTesting
• PolicyInjectionApplicationBlock
• PostSharp
• Prism
• PropertyProxyValidator
• RealTimeSearchMonitor
• RhinoMocks
• RoleProvider
• SCSF
• SCSFContrib
• SearchBundle
• SecurityApplicationBlock
• ServerSideValidationExtender
• ServiceContract
• ServiceFactory
• SiteMapBuilderService
• SoftwareFactories
• Speaking
• SpecSharp
• SpringFramework
• SQLSaturday
• StateValue
• SupervisingController
• T4
• TDD
• TFSPowerTools
• Typemock
• UnitTesing
• UnitTesting
• Unity
• ValidationApplicationBlock
• ValidationCallHandler
• ValidationGuidanceBundle
• Volta
• WCF
• WCFSecurity
• WCSFContrib
• WebClientAuthorizationModule
• WPF
• WPFCompositeClient
• xUnit

Recent Links

• Adobe Flash Player 10 Beta Open: 3D Effects - Enhanced Drawing API - Filters - Advanced Text Layout
• Microsoft Virtual PC 2007 SP1 Download - Windows Server 2008, Vista SP1 and Windows XP SP3
• Dynamic Data Websites - Displaying Tables and Columns using ScaffoldTable and ScaffoldColumn Attributes
• ASP.NET Dynamic Data Websites Preview May 12 Refresh for Visual Studio 2008 SP1 on MSDN Code Gallery
• Dynamic Data Entities Websites - EntityDataSource and ASP.NET Website Scaffolding - Rapid Application Development ( RAD )
• EntityDataSource Companion to ADO.NET Entity Data Model in Visual Studio 2008 SP1
• Download Visual Studio 2008 and .NET Framework 3.5 Service Pack 1 Beta: ASP.NET Dynamic Data - ADO.NET Entity Framework - ADO.NET Data Services
• dotTrace Profiler 3.1 - Support for Visual Studio 2008, Vista and Windows Server 2008
• CodeRush and Refactor! Pro v3.0.8 Download Available - Visual Studio 2008 Add-Ins
• Download Zune 2.5 Software - Gapless Playback - Smart Playlists - Multiple Device Syncing...
• Download XNA Game Developer Studio 3.0 CTP - Zune XBOX 360 Windows
• Expression Web 2 - FTP Explorer to Publish Websites Should be a TreeView
• Expression Design 2 Needs Some Bitmap Graphics Tools like Crop Lasso Magic Wand Marquee
• Popfly Game Creator Alpha Released - Online Tool for Creating Web-based Games
• Coda - Mac Web Design and Web Development Tool
• Free VMware Fusion 1.1.2 Update - Better Support for MacBook Air and Time Machine
• Microsoft Hires Adobe's Former Chief Architect of Photoshop
• Microsoft Expression Studio 2 Released
• SQL Server 2008 Management Studio Gets T-SQL Intellisense
• Composite ASP.NET MVC Applications WCSF, SCSF, and Prism Style