LINQ

We continue post series about Entity Framework usage. We consider the following questions in this article:

• MS SQL Server and Oracle – how to use both in one EF project?
• DDL is generated with wrong keywords.
• What is the difference between .edml and .edmx models?
• Why setting the StoreGeneratedPattern attribute to "Identity" or “Computed” in Visual Studio 2010 does not work as expected?
  
• How can I avoid loading an entire child collection?

(more…)

Some of our users that are working with Entity Framework need to combine Oracle and Microsoft SQL Server in one application. Entity Framework is a powerful ORM with cross-database possibilities, so there is nothing extraordinary in this task.

However, there is a set of pitfalls and difficulties that are not obvious at first glance.

One of our users, Paul Reynolds, has made a series of posts based on his experience for multiple database support in EF:

Preparing for Multiple Databases
Database Caveats
SSDL Adjustments
Database Agnostic LINQ to Entities

This article continues series of publications about non-trivial Entity Framework situations encountered by our users.

We consider the following questions in this article:

• Why Oracle raises an exception about too many local sessions
  participating in global transaction when using TransactionScope?
• How can I optimize SQL queries using Entity Framework?
• How can I perform cascade deleting of objects in Entity Framework?
• How can I get the default value of a database field in my Entity Framework project?

(more…)

ORMBattle.NET has recently updated their results of testing various .NET Framework ORMs and added LinqConnect to their lists. LinqConnect demonstrates one of the best results it their tests.

ORMBattle.NET is an open-source project for ORM comparison, supported by a development team from X-tensive.com. This project contains a set of tests for feature-oriented comparison, but it is more focused on the performance tests (CRUD operation performance, object materialization, etc.).

LinqConnect development team agrees with most of the tests. The results on the whole are reliable enough to consider them when choosing ORM framework.

We already are studying the situations where LinqConnect showed bad results and working on performance improvement.

In this article we continue series of publications about non-trivial situations encountered by our users. Some of these situations are the restrictions of the used platforms, and some simply require a nonstandard approach to solving the problem.

We consider the following questions in this article:

• How can I execute native SQL using Entity Framework?
• How can I use Self-Tracking Entities (STE) or POCO in the Devart Entity Model?
• How can I use Oracle stored procedures with a boolean parameter in Entity Framework?
• How to work with UNION in Entity Framework

(more…)

This article will open a series of publications about non-trivial situations encountered by our users. Some of these situations are the restrictions of the used platforms, and some simply require a nonstandard approach to solving the problem.

Our first post consists of the following users’ questions concerning Entity Framework:

• How to provide the current datetime for record filtering?
• How can I use XML-types from Oracle tables in the Entity Framework model?
• Is ORA_ROWSCN type useful for concurrency handling in Entity Framework?
• What is "outer apply" statement and why isn’t it supported in the Entity Framework statements?

(more…)