In this Video, Sybase iAnywhere Senior Manager of Software Engineering Bill Hillis and Senior Director of Engineering Chris Kleisath discuss how SQL Anywhere version 11 supports ADO.NET Entity Framework and LINQ to Entities. The key benefit to this new version is developer productivity and this eliminates runtime errors.
http://www.sybase.com
[Video Transcript]
SQL Anywhere 11 supports the Entity Framework
Welcome. Im Chris Kleisath, Senior Director of Engineering on the SQL Anywhere team at Sybase iAnywhere. I am here today with Bill Hillis, Senior Manager of Software Engineering on the SQL Anywhere team. Welcome, Bill.
Thanks, Chris.
What does it mean to say that SQL Anywhere is supporting the entity framework?
The entity framework is a new feature that will be part of ADO.net 3.5 that will become available soon when Microsoft ships service pack one of the .net framework and Visual Studio 2008. SQL Anywhere has supported ADO.net development using ADO.net since version 1.0 of the .net framework, and now, we are preparing to release a product that supports the most recent version of ADO.net, including the entity framework. In fact, SQL Anywhere was one of the first database vendors to demonstrate support for the entity framework.
What are the benefits to SQL Anywhere developers and customers?
The key benefit is developer productivity. Previously, when you wrote a program in C Sharp or VB.net, you specified your sequel statement as a quoted string. The compiler had no idea what the context of that string was and, often, you ended up with wrong time errors. With the addition of link, or language integrated query, Microsoft has added features for creating database programs right in the language. Now, using Intelisense, you dont have to worry about making a mistake with table and column names, the compiler helps you to fill that in, and you get compile-time type checking instead of wrong time errors. Another benefit is being able to make use of the entity model in your program. When you develop a database application, you start by developing a conceptual model, defining all of the entities that make sense to your business. Then you translate your conceptual model into a logical model that uses a set of normalized tables and you write your program against this logical model. The entity framework preserves the conceptual model and allows you to program against it and develop in terms of your business entities and not have to worry about the mappings to the logical model. Now, you are able to focus on your business and not on the database schema. The entity framework contains other benefits as well and we know that our customers will want to start to take advantage of this new technology. We are committed to keeping SQL Anywhere at the leading edge of technology development; and, so, we are providing this update to SQL Anywhere so that our customers can start to use the entity framework right away and implement power database solutions.
How will our customers take advantage of this?
You need to get service pack one of Visual Studio 2008 to get the entity framework infrastructure. Once you do that, you just get SQL Anywhere 11 and install it and then youll be able to make use of link, the entity framework, data modeling, all the features of Visual Studio will be available to SQL Anywhere customers.
Thank you, Bill. And, thank you for watching.
Loading...
14:38
Microsoft Entity Framework (Part 1).by thousandtyone18,208 views
Link to this comment:
All Comments (0)