SQLDataSources, LINQDataSources and EntityDatasources in Database Design

In this talk we will contrast and compare developing WebForm applications using Visual Studio 2008 with different types of datasources. We will be looking at design issues relating to concurrency control and updateability when using key Visual Studio controls such as the FormView and ListView controls. So if you don’t know where to start in choosing between SQL, LINQ and Entity datasources then you will by the end of this talk. We will also take a look at techniques for the seamless integration of ASP.net security with SQL Server Login security for web applications using LINQ. General topics:-

  • .net database interfaces in a browser
  • Design philosophy and strategies
  • Datasources; SQL,LINQ and EDM
  • Factors in design choices
  • Multiple-tiers in design
  • Integrating SQL Server security with .net

Detailed topics for contrasting datasources:-

  • View updateability
  • Concurrency control
  • Exploiting CSS
  • Language syntax
  • Navigation
  • Foreign key syntax
  • Model updates
  • Handling null values and controls
  • Dropdown lists and data integrity
Presented by Andrew Couch at SQLBits V
  • Downloads
    Slide deck available Slide Deck 1.4 MB
    Video available WMV Video 205 MB
  • SpeakerBIO
    Andrew has been developing with Access and SQL Server for over 14 years and specialises in Client-Server design applied in the manufacturing and banking sectors. Andrew is a director and one of the founding members of the Access User Group (www.ukaug.co.uk) and technical director of the Office User Group; having acted as magazine editor, running the web site and on many occasions as a guest speaker. Andrew is the author of the popular Migration Upsizing SQL Tool MUST; www.upsizing.co.uk (site features a number of detailed technical articles on upsizing Access databases to SQL Server) and is also a MVP for Office Access. Recently Andrew has been engaged by Microsoft Press as a technical reviewer on Access 2010 Inside Out, and has also entered into a buiness partnership with www.AccessHosting.com to deliver hosted Access Databases in SharePoint 2010 Server.
  • Video