InfoQ Homepage Data Access Content on InfoQ
-
SQLAzureMW Migrates SQL Databases to SQL Azure
The SQL Azure Migration Wizard (SQLAzureMW) is a CodePlex project and wizard that can be used to migrate SQL 2005 and SQL 2008 databases to SQL Azure.
-
ADO.NET Entity Framework Providers for Oracle
Microsoft’s vision for .NET is a wide one. In addition to support for all programming languages, MS wants to bring together all communication frameworks and data storage engines. While WCF is making headway for standardizing communication APIs, their universal data access model Entity Framework is lagging behind. Much is this is due to lack of direct vendor support from companies like Oracle.
-
Fluent NHibernate Has Been Released as 1.0 RC
James Gregory, the owner of the Fluent NHibernate project, has announced his project has reached the 1.0 milestone and it is currently a Release Candidate.
-
Is the NoSQL Meeting Announcing the End of the RDBMS Era?
The NoSQL meeting tried to raise the awareness towards the opportunity of using non-relational databases which promise to be cheaper, simpler to administer and maintain, and offering superior scalability. Michael Stonebraker, co-creator of Ingres and Postgres, thinks that the end of RDBMS era is close, while others think that we are not there yet.
-
Disclosing How C#-SQLite Was Ported to .NET
InfoQ announced the porting of SQLite to .NET two weeks ago. Because the community showed special interest in this project, we interviewed Noah Hart, the developer who did it, to find out how SQLite was re-written in C#.
-
What’s Next for SQL Server?
As we reported last year, SQL Server 2008 R2 will support 256 logical processors. Other features include better multi-server management tools and geospatial visualization in Reporting Services 3. A preview of the new version is available to MSDN and TechNet subscribers. The general public will have access later this month.
-
SQLite Has Been Ported to .NET
Noah Hart has ported SQLite3 to C#. While the first port is slower than the original, the project opens the way for SQLite to be used in .NET managed projects without using P/Invoke or unsafe code.
-
NHibernate LINQ Provider Released
NHibernate Linq 1.0 has been released. Based on the stable provider from NHibernate Contrib, NHibernate Linq 1.0 is a LINQ provider that supports most operations available through the NHibernate criteria query API.
-
Scott Leberknight on Polyglot Persistence
The data persistence solutions in software development have come a long way in the recent years. At the recent Lone Star Software Symposium, Scott Leberknight talked about "Polyglot Persistence" trend where the developers have a choice of different database products like Amazon SimpleDB, Google Bigtable, and CouchDB to choose the data persistence solution.
-
Entity Framework CTP for VS 2010
Not everything planned for Visual Studio 2010 made it in beta 1. This includes some important features for ORM fans. Entity Framework CTP 1 includes support for Self Tracking Entities, POCO Templates, and support for EDMX-free coding.
-
Dynamic Management Capabilities Added to Gemfire Enterprise 6.0
Gemstone has released Gemfire Enterprise 6.0 featuring a cluster resource controller that continuously monitors resources in the distributed data fabric. GemFire enables applications to sense changing performance patterns and proactively provision extra resources and trigger rebalancing of predictable data access, throughput, and latency without the need to overprovision capacity.
-
Microsoft OracleClient Deprecated
Microsoft announced System.Data.OracleClient will be marked obsolete in .NET 4.0 and removed from future releases. OracleClient is the ADO.NET provider for Oracle developed by Microsoft and shipped as part of the .NET FCL. Its absence will be an impediment to future upgrades for the many small projects using this provider for Oracle data access.
-
Goat Rodeo: A Unified Data Model for Web Applications
David Pollak, found of the Lift web framework and "Beginning Scala" author, has announced a new initiative "Goat Rodeo" that aims to bring data modeling into the 21st century.
-
Wrapping Stored Procedures in .NET Languages
Creating wrapper functions for pre-existing stored procedures is surprisingly difficult in .NET. Stored procedures have certain calling conventions that aren’t generally used in the .NET Framework and many of them are not supported at all. For example, C# doesn’t support optional parameters and neither .NET language supports optional parameters on nullable types.
-
LINQ to SQL Changes in .NET 4.0
Damien Guard of Microsoft’s Data Programmability has posted a rather long list of the changes to LINQ to SQL. While they are still committed to Entity Framework over the long run, this will do much to alleviate the fear LINQ to SQL will be completely neglected in the mean time.