Dynamic CRM - Fetch XML with No Lock

In this post, we will review, how to write a Fetch XML with No lock implemented. This feature will enhance the execution of SQL and will be safer to be run in any environment(s).  Lets review a sample SQL with no lock attribute and will follow with an example on how to using Fetch XML.


SELECT * FROM Employee WITH (NOLOCK);

The above can be implemented using Fetch XML as :

Happy coding...