LINQ entity forms the main heart of LINQ engine. All the data from database is fetched using ‘datacontext’ and given to LINQ objects. Once the data is fetched in the LINQ objects the LINQ objects gets disconnected from the database, in other words LINQ is a disconnected architecture. Due to disconnected architecture the only type of locking we can support is optimistic locking.
Good news !!! LINQ supports optimistic concurrency by default.