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…)

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…)

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…)