Greetings,
I am currently smashing my head into the wall and for all the results i have found towards the issue; say i should be doing the right thing.
so here goes:
I have a quite simpel datamodel.
login --> user
where the logintabel has the following columns:
- login_unique (PK)
- user_unique (FK)
- username varchar(250)
- password varchar(256)
- usergroup int (FK)
and the usertabel has the following columns:
- user_unique (PK)
- firstname
- prefix
- lastname
- country (FK)
so i made a simpel store procedure:
select login_unique, user_unique, username, password, usergroup from
project_login as l
where l.password = @password and l.username = @username
so i used a Nhibernate mapping to call it:
<sql-query name="spProject_login">
<return class="Project.Core.Domain.project_login, Project.Core">
<return-property name="firstname" column="firstname" />
<return-property name="lastname" column="lastname" />
</return>
exec SPProject_Login :@username, :@password
</sql-query>
and the project_login class
project_login is a class with the following for each of the columns.
private Guid _login_unique;
public virtual Guid login_unique
{
get { return _login_unique; }
set { _login_unique = value; }
}
tipped off with and Ilist for the userclass, which i bound by the one-to-many relation..?
private IList<user> _user = new List<user>();
public virtual IList<user> user
{
get{ return _user;}
protected set { _user = value; }
}
and i call it:
IQuery query = NHibernateSession.GetNamedQuery("spProject_login");
query.SetString("@username", username);
query.SetString("@password", password);
return query.List<project_login>() as List<project_login>;
now i can call the function with some parameters and Nhibenate hydrates it towards the database like i would expect:
exec sp_executesql N'exec SPProject_Login @p0, @p1',N'@p0 nvarchar(8),@p1 nvarchar(8)',@p0=N'username',@p1=N'password'
if i execute that directly on the data, it returns values foreach of the columns in project_login.
so what is nhibernate telling me?
thanks for reading the rather long post.
Kinjara
Login
FAQ
Search