Dear users, Devart is delighted to introduce the new version of Entity Developer with support for named SQL queries and stored procedures in NHibernate models.
New version of Entity Developer extends NHibernate mapping support - now it allows creating methods from SQL queries. For this named SQL queries feature of NHibernate is used. Entity Developer interprets named SQL queries as methods of the model, for which a helper class containing the corresponding methods will be generated.
Entity Developer allows creating methods returning scalar or entity results or no result. The named SQL queries feature can also be used for creating methods calling stored routines. For stored routines, you don't need to write SQL manually, just specify the name of the routine and Entity Developer will generate the query automatically.
Entity Developer offers you even more if you use database first approach. You can generate methods from stored routines just by selecting them in the Create Model Wizard when creating model. It is also possible to create a method in the model by dragging the corresponding stored procedure or function from Database Explorer to the diagram area or in the Model Explorer window. Moreover, with the help of Update From Database Wizard it is possible to add new and modify the existing methods in the model.
To demonstrate how to implement and use named SQL queries along with many other kinds of NHibernate mapping, Devart releases NHibernate Mapping Samples application, which demonstrates 50 different mapping cases, how they are mapped using both fluent and XML mapping, and their usage. Visit our NHibernate Mapping Samples blog article to read more about this application and download it.
You are welcome to download Entity Developer here.
If you wish to provide feedback on the new version, you can do it on our forums or with the contact form. There is also a feedback form, and we are always glad to have your comments and take into account your development needs.
If you want to share your ideas about new Entity features, you may do it on the UserVoice.
Devart development team
http://www.devart.com/entitydeveloper/