What are some good Entity Framework Alternatives [

Question

Closed. This question does not meet Stack Overflow guidelines. It is not currently accepting answers.

---

Want to improve this question? Update the question so it's on-topic for Stack Overflow.

Closed 6 years ago.

Improve this question

I am using the Entity Framework now and constantly having to write inline sql because Entity framework does not support full text search and other features. Is there a ORM out there that has many features that supports advanced queries? I feel if I am going to sometimes write inline sql I might as well do all of it in inline sql. Any help here

Answer 1

Take a look at:

• LINQ queries in DataObjects.Net. If you're interesting in most complex parts, start from the tail.
• Advanced LINQ in DataObjects.Net. Some underlying SQL queries are shown there.

Answer 2

Seconding what the others said, nHibernate. Plus I found this link re: full text search and nHibernate.

Answer 3

I feel if I am going to sometimes write inline sql I might as well do all of it in inline sql

Seriously? When using any ORM, you're always going to hit situations where it is better, cleaner, or more performant, to use SQL or call a stored proc. You shouldn't just blindly trust it do absolutely everything for you in all situations.

Answer 4

Mindscape LightSpeed is an o/r mapper for .NET that supports full text search (via Lucene but extensible so you could add your own).

It also supports LINQ, has a Visual Studio integrated designer with full schema round tripping so you can work model-first or database-first - whichever takes your fancy :-)

There is also a free version that you can use to decide if it is right for you.

I hope that helps.

Answer 5

You might look CodeFluent Entities but you need to understand that it does not internally rely on any ORM or third party tool.

Entity Framework is an ORM whereas CodeFluent Entities is a full model-first software factory. It uses a natural and visual modeling approach (like Entity Framework and integrated into Visual Studio) and can generate database scripts, object oriented data layer - code (C#, VB), web services and even UIs components.

Answer 6

I'm a fan of SubSonic by Rob Conery. It is (was) simple and easy to set up and use.