CODEWITHSUNDEEP
ormlinq-to-sql
Dindar
Dindar

Reputation: 3235

What are Disconnected ORM and Connected ORM

Could any body clarify these two expression for me ?

What are cons and pros of each one ?

I've just worked and familiar with CodeSmith and Linq to sql among all ORM Tools

Upvotes: 0

Views: 644

Answers (2)

JohnB
JohnB

Reputation: 18992

Well here are some cons to maintaining a connection to your database for an increased length of time:

  1. memory on the database to maintain the connection
  2. tying up a connection from the pool, which may be a finite resource
  3. concurrency issues due to locking data

Convenience might be a pro.

Upvotes: 0

Felix Ungman
Felix Ungman

Reputation: 512

It refers to whether you can disconnect the database session and still expect the entities to be "alive". In disconnected ORMs you can disconnect and reconnect a database session (e.g. between web page requests) while retaining entity objects (e.g. in a web session state).

Personally I prefer not to work in disconnected mode (I'm mostly using NHibernate), because although it seems to simply things there will sometimes be side effects that are tricky to debug.

Upvotes: 2

Related Questions