1 / 23

Visual Studio + SQL Server Is Better

Visual Studio + SQL Server Is Better. Børge Hansen. Visual Studio Team System 2008 Database Edition ADO.Net Entity Framework ADO.Net Data services Sync Services for ADO.Net. VSTS Database Edition. Source control of all database objects. Code Analysis on T-SQL code Dependency tree

allistair-buck
Download Presentation

Visual Studio + SQL Server Is Better

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Visual Studio + SQL Server Is Better Børge Hansen

  2. Visual Studio Team System 2008 Database Edition • ADO.Net Entity Framework • ADO.Net Data services • Sync Services for ADO.Net

  3. VSTS Database Edition • Source control of all database objects. • Code Analysis on T-SQL code • Dependency tree • Unit testing • Refactoring • Data compare/Schema compare

  4. VSTS Database Edition Edit Refactor Compare Database Project Deploy Build Data Generation Test Compare

  5. DEMO

  6. ADO.Net Entity Framework

  7. LINQ to * • LINQ to Object • LINQ to Entities • LINQ to SQL • LINQ to XML • LINQ to [YourToolHere]

  8. ADO.Net Entity Framework

  9. Object Services

  10. Models, Mapping and Objects

  11. DEMO

  12. ADO.Net Data Services

  13. ADO.Net Data Services

  14. ADO.Net Data ServicesData Exchange

  15. DEMO

  16. Sync Services for ADO.NET • Sync Services for ADO.NET • In Beta Now – ships with SQL Server Compact 3.5, VS 2008 • Works with VS 2005, .NET FX 2.0 • Builds on ADO.NET skills, Developer Productivity w/many features of Merge Replication • Visual Studio 2008 • RAD configuration of Sync Services and SQL Server Compact • SQL Server 2008 • Integrated change tracking making SQL Server 2008 your best server

  17. ADO.Net Data access DataAdapter SelectCommand Server DB InsertCommand Connection Forms UpdateCommand DeleteCommand

  18. Sync Services for ADO.NET Select Incremental Inserts Select Incremental Updates DataAdapter SyncAdapter Select Incremental Deletes Server DB InsertCommand Connection Forms UpdateCommand DeleteCommand Select Conflict Updated Rows… Select Conflict Deleted Rows…

  19. Sync Services for ADO.NET Select Incremental Inserts Select Incremental Updates SyncAdapter Select Incremental Deletes Server DB InsertCommand Connection Forms UpdateCommand DeleteCommand Select Conflict Updated Rows… Select Conflict Deleted Rows… SQL Server Compact 3.5

  20. Delivering an OCS Vision VS 2005 SP1 Visual Studio 2008 SQL Server 2008

  21. More on... Visual Studio Team System 2008 Visual Studio 2008 and .NET Framework 3.5 Service Pack 1 Beta ADO.NET Entity Framework Overview ADO.NET Data Services Microsoft Sync Framework Developer Center

More Related