Welcome to MSDN Blogs Sign in | Join | Help

DataDirect has released the much anticipated Beta of their DataDirect Connect for ADO.NET Entity Framework provider for Oracle!

DataDirect’s Beta release of its Entity Framework provider for Oracle offers:

  • 100% managed code architecture
  • Superior performance and including integrated performance tunability wizards functional with the Entity Framework
  • 7 x 24 phone, email, and web-based technical support.
  • Support for security features including Kerberos and SSL
  • Supports reliability features including application failover and Oracle RAC
  • Support for key Oracle features including schemas, REF CURSORs, and packages
  • Extensive Oracle data type support including BLOB, BLOB, BINARY, and XML
  • Provides interoperable platform for future DataDirect ADO.NET Entity Framework providers

For more information or to download the Beta check out

http://www.datadirect.com/products/net/beta/index.ssp

 

-Elisa Flasko
Program Manager, Data Programmability

The Data Programmability Tools team is currently running a survey with the goal of prioritizing ‘value add’ features for a database designer.  If you’re interested in helping shape the future of MS database design tools, please take ten minutes and fill out the survey at the following link.  We’d appreciate your input!

 

https://MSCUILLUME.smdisp.net/Collector/Survey.ashx?Name=DBDiagramming&LoginId=

 

Thanks ,Tim Laverty

Microsoft PM, Data Programmability Tools

We are excited to announce the newest release of the Microsoft SQL Server JDBC Driver! This version of the JDBC driver provides support for the JDBC 4.0 API, including new national character set conversion methods, new metadata methods, and new data types like SQLXML, as well as a host of performance improvements and bug fixes. The latest version also enhances the tracing operation by logging the entry and exit points of public methods and by providing better distinction between the trace levels. Please feel free to download a copy and see for yourself!

 

- JDBC Team

Microsoft's premier developer event, the Professional Developer Conference, is almost here. PDC 2008 will feature more than 160 sessions covering a wide range of topics including a number of great sessions from the Data Programmability Team, including the ADO.NET Entity Framework, ADO.NET Data Services and Project "Velocity".

Developing Applications Using Data Services

Presenter: Mike Flasko

In the near future, applications will be developed using a combination of custom application code and online building block services, including data-centric services. In this session we discuss advancements in the Microsoft development platform and online service interfaces to enable seamless interaction with data services both on-premises (e.g., ADO.NET Data Services Framework over on-premises SQL Server) and in the cloud (e.g., SQL Server Data Services). Learn how you can leverage existing know-how related to LINQ (Language Integrated Query), data access APIs, data-binding, and more when building applications using online data.

Offline-Enabled Data Services and Desktop Applications

Presenter: Pablo Castro

The ADO.NET Data Services Framework (a.k.a. Project "Astoria") introduced a way of creating and consuming flexible, data-centric REST services. By combining data services with the Microsoft Sync Framework, learn how to create offline-capable applications that have a local replica of their data, how to synchronize that replica with an online data service when a network connection becomes available, and how replicas can be used with the ADO.NET Entity Framework. Also, hear us talk about our plans, see the tools that help client- and server-side setup, and discuss the runtime components and APIs.

clip_image002

Entity Framework Futures

Presenter: Tim Mallalieu

The next version of the Entity Framework adds scenarios in the areas of   model driven development, domain driven development, simplicity, and integration. See a preview of production and prototype code for the next version of the Entity Framework as well as a candid discussion with members of the development team.

 

Project "Velocity": A First Look

Presenter: Murali Krishnaprasad

It is predicted that all large applications will use a distributed data cache as the initial tier for all data access. This session presents an overview of "Velocity," Microsoft's distributed in-memory cache, and shows how it works with IIS, ASP.NET, ADO.NET and SQL Server Data Services.

Register at http://microsoftpdc.com/Registration/

See you there!!

Elisa Flasko
Program Manager, Data Programmability

Announcing Entity Framework & ADO.NET Data Services RTM!

We are excited to announce the RTM of the Visual Studio 2008 SP1 and the .NET Framework 3.5 SP1, including the RTM of the ADO.NET Entity Framework and ADO.NET Data Services, which raise the level of abstraction for database programming and supply both a new model-based paradigm and a rich, standards-based framework for creating data-oriented Web services. With this service pack, Visual Studio 2008 and the .NET Framework 3.5 also support SQL Server 2008, making the Microsoft platform the most comprehensive environment for database application development.

“The ASP.NET AJAX improvements and new capabilities like ADO.NET Entity Framework and ADO.NET Data Services meant we didn’t have to worry about any of the underlying plumbing and could simply focus on building a highly responsive and interactive experience for users,” says Galen Murdock, President and CEO at Veracity Solutions. (Link to Official Press Release)

For more information or to download check out http://msdn.microsoft.com/data  

Elisa Flasko
Program Manager, Data Programmability

The Data Programmability XML Tools team is conducting a survey focused on XML technology and tools usage over the coming weeks.  The survey takes about 15 minutes to complete and we’d appreciate it if you would take the time to respond to it.  We plan to use the survey results to help drive prioritization of features over the coming releases of Visual Studio and SQL Server.

The survey can be found here:  https://mscuillume.smdisp.net/Collector/Survey.ashx?Name=XMLTools

Thanks,
Tim Laverty
PM, XML Tools

The advances in processors, memory, storage, and connectivity have paved the way for next-generation applications that are data-driven, whose data could reside anywhere (i.e. on the desktops, mobile devices, servers, and in the cloud) and that require access from anywhere (i.e. local, remote, over the network, from mobile devices, in connected and disconnected mode). This trend has led to the development of distributed, multi-tiered, and composite application architectures for the web and for the enterprise. A typical enterprise application accesses data from multiple data sources, integrates that data, re-shapes (or transforms) that data into a form most suitable for the application (typically into object form like C# or Java object), and writes application logic. The same is true of web applications – consider social networking apps or mashups – they access data from multiple web sources, over the internet, aggregate it, execute application logic, and generate pages for web interaction. As these styles of multi-tiered web and enterprise application are becoming main stream, the demand for application performance and scale is increasing. End users become less tolerant and more frustrated when a web application cannot respond in milliseconds; web applications that cannot scale, as the number of concurrent accesses increase, lose traffic and thereby business. Fundamentally, we have all begun to expect high performance and scale from every application. And let’s not forget application availability. For similar reasons to those I describe above, an application cannot be down. We cannot imagine the MSN portal or the Amazon web site, or the corporate SAP financial application being down when we need it. We expect to access our personal information on MSN at any time; consumers do business with Amazon at any time and from anywhere. Fundamentally, applications need to be available all the time to support access at any time, and from anywhere. Another major expectation, especially from application developers and from application hosters is that of scalable and available applications at a low cost. A decade ago, only mission-critical businesses could afford to invest in large and expensive infrastructure (both hardware and software) to support scale and availability of their applications. But, now with web hosting, everyone expects and demands high scale and availability at low cost. Extending this even further, not only developers want cheap scalable and available applications, they want the ability to develop (and deploy) such applications very rapidly.

To cope with competitive pressure, both from an innovation and a deployment perspective, rapid development and deployment of these applications is critical for application vendors.  In turn, application developers are looking for application infrastructure that enables them to build highly performant, scalable, and available applications using commodity hardware and software, at a rapid pace. Traditional application platforms like the .NET and Java platforms, which are known for rapid multi-tier application development and deployment, are required to provide the scalability and availability infrastructure. 

Distributed cache is becoming the key application platform component for providing scalability and high availability. In-memory caching has been traditionally used primarily for meeting the high performance requirements of applications. By fusing caches on multiple nodes into a single unified cache however, the distributed caches offer not only high performance, but also scale. By maintaining copies of data on multiple cache nodes (in a mutually consistent manner), the distributed cache can also offer high availability to applications. Distributed caches are especially ideal for applications with the following characteristics:

  • There is a considerable number of data requests that are mostly read (e.g. product catalogs)
    • Large concurrent access to such data can be provided by replicating the catalog data on multiple cache nodes. Since updates are infrequent to such data, maintaining consistency (synchronously or asynchronously) is not very expensive
  • Applications that can tolerate some staleness of data
    • Such applications can provide better performance and scale by not requiring immediate updates ore refreshing of caches
  • Applications that can work with highly partitioned data (e.g. session data, shopping cart)
    • High scale and performance can be supported by partitioning and distributing data across multiple cache nodes, and thereby distributing data processing across the cache nodes
  • Applications that can work well with eventual consistency
    • Consider a flight inventory application, which must satisfy a large number of concurrent read/writes to the inventory of seats. To support large scale, the distributed cache may replicate the inventory value on multiple nodes; however, the inventory values on different nodes have to be made consistent in some fashion.  Requiring immediate (also known as strong) consistency will require updates to be synchronously propagated to all the copies. Such action would impact the overall performance and scale of the application. However, instead of immediately making the copies consistent, allowing them to eventually (in an asynchronous manner) become consistent will provide low latency, high performance access to inventory.

As distributed caches become more widely deployed, I believe over the next few years, distributed cache will be used as the first tier of all data access. Multi-tier application architecture will include the cache tier as a data access tier between the application server tier and the backend data tier.

Today, Microsoft is announcing the first CTP of a distributed caching product to provide the .NET application platform support for developing highly performant, scalable, and highly available applications. The project code named “Velocity” is a distributed cache that allows any type of data (CLR object, XML document, or binary data) to be cached. “Velocity” fuses large numbers of cache nodes in a cluster into a single unified cache and provides transparent access to cache items from any client connected to the cluster. The Data Platform Developer Center at http://msdn.microsoft.com/data and the Velocity Team Blog at http://blogs.msdn.com/velocity provides additional information about project code named “Velocity” as well as links to download our first CTP.

Distributed caches are not new – during the last couple of years several caching products have emerged to address the performance and scalability needs of applications. Most of these products are point products, primarily supporting key-based access. Other than memcached, which is an open source technology, most others target enterprises and enterprise workloads and scale. I think the web workloads require considerably large scale, with 1000s of cache nodes in a cluster. The web scale distributed caches not only require mechanisms that can scale and provide availability in very large clusters, they must be easy to manage or self-managed. In the Future, “Velocity” envisions being an integral part of the .NET application stack targeting both enterprise and web workloads (and scale). As applications start using the caches for data access, I also believe, they will demand richer data services like query, transactions, analytics, synchronization etc. For example, we believe .NET applications will require LINQ queries on the distributed cache, the same way they query the backend SQL Server database. We envision “Velocity” becoming such a comprehensive distributed caching platform. The performance, scale, and availability functionality of “Velocity” along with its rich data services will allow for rich web and enterprise applications development and deployment.

Anil Nori
Microsoft Distinguished Engineer

The SQL Server JDBC team is running at full speed working on the next JDBC driver for SQL Server.  We are looking for people to share in our excitement about the future of data access for SQL Server and to manage the quality of our next deliverables. 

 

Are you passionate about working with data, the powerful query capabilities of T-SQL, the power of Object Oriented programming languages like Java, C#, C++? Are you interested in designing the next set of API’s for data and want to work for a team that’s focused on shipping technologies and having fun?  

 

We are interested in hearing from you.  Drop us a line through the team blog or directly to me and we’ll get back to you.

 

Uwa Agbonile

SQL Server JDBC/SNAC/PHP Teams

Uwa.Agbonile@microsoft.com

Do you want to work on the next generation of data access APIs for the web?  If so, the Astoria and XML teams are hiring.  If you want to get a feel for the types of problems our team thinks about the solutions we build, check out the earlier posts on this blog as well as

http://msdn.microsoft.com/data and http://msdn.microsoft.com/xml

We have a range of job openings across disciplines (Development, Developer in Test and Program Management) available on the Astoria and XML teams.  If you are interested in any of these positions, please send myself (mike.flasko@microsoft.com) and Andy Conrad (aconrad@microsoft.com) email.

For more details on each of the open positions, please see:

ADO.NET Data Services PM

XML PM

XML PM

ADO.NET Data Services SDE

ADO.NET Data Services SDE

XML SDE

ADO.NET Data Services SDE/T

ADO.NET Data Services SDE/T

XML SDE/T

We look forward to talking with you...

Thanks,

Mike Flasko : ADO.NET Data Services ("Astoria"), Program Manager

We are very excited about .NET 3.5 SP1 and Visual Studio 2008  SP1 and what this update means for developers who use ADO.NET for data development.  This beta marks the entry of the ADO.NET Entity Framework and ADO.NET Data Services (aka project Astoria) as part of the overall .NET/Visual Studio beta install. This public release is also the final beta before the RTM of these two technologies. In addition, we have a revision of LINQ to SQL  that introduces the new date time functions for SQL Server 2008.

 

In the space of a few short months developers have been able to experience a wave of innovation in the .NET data programming space. We began with the introduction of LINQ in .NET Framework 3.5 for providing a compile time query experience over in-memory objects, XML and relational data, and now we’re adding the Entity Framework runtime and graphical entity designer into the mix.  The Entity Framework extends the reach of ADO.NET, providing a new data model that will be the foundation for a range of data services moving forward. We’ve also enhanced the common ADO.NET provider model enabling a LINQ programming experience against 3rd party databases.  The Entity Framework designer in Visual Studio works with 3rd party databases as well and enables developers to visualize the data model being used by the application.

 

Over the last year or so we’ve seen a growing trend in the way people build services.  They tend to either be operation-centric with a focus on actions occurring on either side or they are resource-centric, where the focus is on working with the data or resource on either side.  For operation-centric services the Windows Communication Foundation (WCF) and Windows Workflow (WF) teams have done a bunch of work in .NET 3.5 to make it easier to build these action oriented service interfaces as a workflow.  On the data-centric side, the Data Programmability team has been working with the WCF team to deliver ADO.NET Data Services.  This is one of the most exciting new additions to the platform in some time, providing the foundation for building the next generation of data-driven applications and services today. These data services build on the WCF classes to provide an end-to-end experience for building data-centric REST based services in .NET.  They have a REST based query model, a means of exchanging metadata (in terms of the Entity Data Model) and client and mid-tier API’s that let people build rich data services and clients in a way that is easier than ever before. Developers can start with the Entity Framework and expose relational data via the Data Services Framework, they can expose non-relational data using a custom provider, or they can use some of the existing services that already expose these protocols.

 

·         Live App Storage

·         Live Spaces Photos


In summary, it is an exciting time to be working with data on the .NET platform.  The team is looking forward to your feedback.  We invite you all to download this beta and start using these technologies today.

 

 

Sam Druker

General Manager, Data Programmability

We’re gearing up for the next release of the SQL Server, and we are looking for people that have a passion for building great data access technologies and frameworks to help with the effort.  We have been very busy recently releasing:

·         Microsoft .NET Framework 3.5 (includes .NET Framework Data Provider for SQL Server aka SqlClient)

·         Microsoft SQL Server 2008 Feature Pack CTP, February 2008 (includes Microsoft SQL Server 2008 Native Client)

·         SQL Server 2005 Driver for PHP Community Technology Preview (February 2008)

·         Microsoft SQL Server 2005 JDBC Driver 1.2

If you are interested in designing the next set of API’s and tackling challenging technical subjects across all our SQL Server data access stacks and want to work for a team who is focused on shipping great technologies, we’re interested in hearing from you. Drop me a line directly at ddove@microsoft.com.

Debra Dove
Lead Program Manager

Since posting on the topic of design-time and runtime connectivity to pre-release versions of SQL Server 2008 on the Data blog in November, the set of affected clients (applications, runtimes, and operating systems) have been officially released: Microsoft Visual Studio 2008, Microsoft .NET Framework v3.5, Microsoft Vista Service Pack 1, and Microsoft Windows 2008. Runtime connectivity from a client system configured with any of these released products to SQL Server 2008 November CTP or later provides full runtime access to the following features (for design-time functionality, see below):

·         Table-Valued Parameters

·         New date/time data types

·         Large user-defined types

·         Support for very large FILESTREAM-attributed column data

Design-Time Connectivity Between Visual Studio and SQL Server 2008

Developers using Visual Studio 2005 or Visual Studio 2008 design tools will receive an error when trying to open a database on any pre-release instance of SQL Server 2008 without installing a Visual Studio patch. Pre-release patches for Visual Studio 2008 and Visual Studio 2005 enable the following Visual Studio functionality for SQL Server 2008:

·         Server Explorer successfully connects to SQL Server 2008, and database objects such as stored procedures and table data can be viewed and edited.

o   Note that table schemas still cannot be viewed or edited in this release.

·         SQL CLR projects that target SQL Server 2008 can be created and deployed to the server.

·         T-SQL and SQL CLR debugging are now enabled for SQL Server 2008.

·         Data binding features in Client and Web Projects are enabled.

 

Pre-release versions of the design-time patches are currently available: the Visual Studio 2008 CTP patch is available for download here and the Visual Studio 2005 CTP patch is available for download here. Final versions of the patches will be available in the near future. For more information please see the "Connecting to Microsoft SQL Server 2008 from Microsoft Visual Studio 2005 and 2008" whitepaper on MSDN.

 

 

Debra Dove

Program Manager Lead, Data Programmability

We’re pleased to announce that 64-bit MSDASQL for Windows Server 2003 is now available for download at  http://www.microsoft.com/downloads/details.aspx?FamilyID=000364db-5e8b-44a8-b9be-ca44d18b059b. This update will also be available through “Windows Update” soon.

 

What is MSDASQL?

MSDASQL is an OLEDB/ODBC ‘bridge’ that allows applications built on OLEDB and ADO (which uses OLEDB internally) to access data sources through ODBC drivers. MSDASQL ships with the Windows Operating System, and Windows Server 2008 and Windows Vista SP1 are the first Windows releases to include a 64-bit version of MSDASQL.

 

Isn’t MSDASQL Deprecated?

Previous messaging on MSDN indicated that a 64-bit version of MSDASQL would not be available. However, we have received numerous requests from customers for this technology and we are making it available on the following Windows operating systems:  Windows Server 2003, Windows Vista SP1 and Windows Server 2008. Microsoft has no plan yet to deprecate this technology currently.

 

Mo Lin

Program Manager, Data Programmability

We’re gearing up for the next release of the .NET Framework, and we are looking for people that have a passion for building great frameworks to help with the effort.  Since we’ve shipped the .NET Framework 3.5 we’ve been working on projects like the ADO.NET Data Services Framework (aka Astoria) and LINQ to XML support in Silverlight.  If you’re interested in designing the next set of API’s for data and want to work for a team that’s focused on shipping technologies and having fun, we’re interested in hearing from you.  Drop us a line through the team blog or directly to me and we’ll get back to you.

Carl Perry
Lead Program Manager

cperry@microsoft.com

I just got back from the h^3 launch event in LA and found a few nifty-cool things waiting for me in my aggregator. First, the ever practical (and prolific) Julie Lerman is writing a book on the ADO.NET Entity Framework for our friends at O'Reilly. Very cool indeed.

Also waiting for me was the news that Ruurd Boeke has started the EFContrib project over on Codeplex. He's got a couple projects going on up there already. Using a postcompiler here is a pretty cool idea, and Ruurd's definitely making the EF sing and dance here.

  1. PostSharp4EF: Automatically implement IPoco This project uses PostSharp to post-compile your assemblies. When it encounters a simple attribute, it will implement everything needed to use it in EF: Typelevel attributes, EDMscalar attributes, changetracking and default values. This means there are no runtime performance penalties. See Introducing EF Contrib post for more detailed information about this project.
  2. Plug-in Edmx Code Generator: easily add assemblies that will hook into the codegeneration part of Entity Framework. Check this blog post out for more info!

Finally, our friends in the SQL Server Compact team have released an EF provider for their 3.5 Beta 1 release. This is wicked cool.

More Posts Next page »
 
Page view tracker