30th September - 2nd October 2010

University of York

Gold sponsors
Silver sponsors
Bronze sponsors

ADO.NET Entity Framework - Programming Against a Model, Not Against the Database

Developers spend too much time writing view, stored procedures and setting relationships and worrying about their backend

The Entity Framework is designed to enable developers to create data access applications by programming against a conceptual application model instead of programming directly against a relational storage schema.

We can focus on the task of writing our applications, rather than accessing the data.



Applications can work in terms of a more application-centric conceptual model, including types with inheritance, complex members, and relationships.

  • Applications are freed from hard-coded dependencies on a particular data engine or storage schema.
  • Mappings between the conceptual model and the storage-specific schema can change without changing the application code.
  • Developers can work with a consistent application object model that can be mapped to various storage schemas, possibly implemented in different database management systems.
  • Multiple conceptual models can be mapped to a single storage schema.
  • Language-integrated query support provides compile-time syntax validation for queries against a conceptual model.
  • Adding functionality to a pre-built is relatively seamless.

Speaker focus

Ashwani Roy

as.jpg
Ashwani Roy is SQL Server MVP and Senior Consultant with Information Management Group (IMGROUP), winners of the Microsoft Global Business Intelligence Partner of the Year award for the past four years. Ashwani has worked with SQL Server BI stack since 2003 and is Microsoft Certified IT Professional. His main field of expertise are SQL Server Analysis Services, MDX, SQL Server Database Engine, T-SQL, and SSIS and C #.

Ashwani Roy's blog http://ashwaniroy.spaces.live.com



Downloads

No items to download

Other sessions from this conference

Denormalisation –having your cake and eating it.
Design patterns for SSIS Performance
Designing and Tuning high speed data loading
Event Driven Cube Performance and Security Monitoring
Fast Track Foundations: Get Serious about Sequential I/O
Getting Started with SQL Azure
High Availability in the Real World!
High performance functions
Improving Database Performance by Removing the Database
Inside the SQL Server Query Optimizer
Introduction to Performance Tuning Analysis Services 2008
Lessons Learned from 128 Core OLTP Testing
Make your DBA life better using SQL Server technologies - notes from field & best practices
Monitoring and Tuning Parallel Query Execution
Non-Functional Dependencies - A talktorial on getting performance and scalability right through proper Database Design and understanding Set and Relational theory
Optimizing tempdb and temporary object use
Performance Management for SQL Server with SCOM 2007
Performance Monitoring & Tuning - Documented Tips & Tricks
Performance Troubleshooting made easy with PAL
Photograph: SQL Server Crash Dump Analysis
Scaleout scenarios with Service Broker
SQL Server 2008 Reporting Services Scalability and Performance
Supercharge MDX performance using MDX Studio
Transaction Log Performance Tuning, Stop shouting Timber!