In my application I have a database view. (sql server express)

This requisite is not necessarily a business object. I wouldn't like to create a object just to agree NHibernate architecture.

there are few other cases that I will have that behavior.

I've tried this..




but I get this error...


{"in expected: <end-of-text> (possibly an invalid or unmapped class name was used in the query) [select * from TagsView]"}



The question are:

- returning collections using queries without object mapping
- returning a simple data like the amount of records in the dataabse

How would I solve this problem?[/b]

http://www.hibernate.org/hib_docs/nhibernate/1.2/reference/en/html/querysql.html#d0e8963.

that didn't work.

I just get an error saying sth like "No Type specified"

What have I to do (configuration?) in order to work without mapping?

Did you try using the alias-to-bean result transformer? (see 13.1.5)

You can use AliasToEntityMapResultTransformer to return data as dictionary.

If you just want to use your objects without mapping, you can do something like this:

For example, in HQL you can say something like this:

Obviously, this needs mapping for MyMappedClass. But, you can also use this:

So, if you want this:

you have to add an <import> somewhere in mapping file:
.
NOTE <import> should be placed before <class>
Also, you could try using NHibernate.Cfg.Mappings.AddImport

HTH, Tom

I got what you said!

But I'd like to see a real example.

Would you mind sending me a link that contains an example, please?

anyway I'll look for it on the internet.

thanks!