http://wiki.nhibernate.org/display/NH/Home
http://sourceforge.net/project/showfiles.php?group_id=73818
Quick Start †
- NHibernate
use NHibernate
go
CREATE TABLE users (
LogonID nvarchar(20) NOT NULL default '0',
Name nvarchar(40) default NULL,
Password nvarchar(20) default NULL,
EmailAddress nvarchar(40) default NULL,
LastLogon datetime default NULL,
PRIMARY KEY (LogonID)
)
go
- NHibernate
-
using System;
namespace NHibernate.Examples.QuickStart
{
public class User
{
private string id;
private string userName;
private string password;
private string emailAddress;
private DateTime lastLogon;
public User()
{
}
public string Id
{
get { return id; }
set { id = value; }
}
public string UserName
{
get { return userName; }
set { userName = value; }
}
public string Password
{
get { return password; }
set { password = value; }
}
public string EmailAddress
{
get { return emailAddress; }
set { emailAddress = value; }
}
public DateTime LastLogon
{
get { return lastLogon; }
set { lastLogon = value; }
}
}
}
-
<?xml version="1.0" encoding="utf-8" ?>
<hibernate-mapping xmlns="urn:nhibernate-mapping-2.0">
<class name="NHibernate.Examples.QuickStart.User, NHibernate.Examples" table="users">
<id name="Id" column="LogonID" type="String" length="20">
<generator class="assigned" />
</id>
<property name="UserName" column= "Name" type="String" length="40"/>
<property name="Password" type="String" length="20"/>
<property name="EmailAddress" type="String" length="40"/>
<property name="LastLogon" type="DateTime"/>
</class>
</hibernate-mapping>
-
&ref(): File not found: "BuildAction.PNG" at page "NHibernate";
-
<?xml version="1.0" encoding="utf-8" ?>
<configuration>
<configSections>
<section
name="nhibernate"
type="System.Configuration.NameValueSectionHandler, System, Version=1.0.5000.0,Culture=neutral, PublicKeyToken=b77a5c561934e089"
/>
</configSections>
<nhibernate>
<add
key="hibernate.connection.provider"
value="NHibernate.Connection.DriverConnectionProvider"
/>
<add
key="hibernate.dialect"
value="NHibernate.Dialect.MsSql2000Dialect"
/>
<add
key="hibernate.connection.driver_class"
value="NHibernate.Driver.SqlClientDriver"
/>
<add
key="hibernate.connection.connection_string"
value="Server=localhost;initial catalog=nhibernate;Integrated Security=SSPI"
/>
</nhibernate>
</configuration>
Insert †
- NHibernate
using NHibernate;
using NHibernate.Cfg;
-
Configuration cfg = new Configuration();
cfg.AddAssembly("NHibernate.Examples");
-
ISessionFactory factory = cfg.BuildSessionFactory();
ISession session = factory.OpenSession();
-
ITransaction transaction = session.BeginTransaction();
-
User newUser = new User();
newUser.Id = "joe_cool";
newUser.UserName = "Joseph Cool";
newUser.Password = "abc123";
newUser.EmailAddress = "joe@cool.com";
newUser.LastLogon = DateTime.Now;
-
session.Save(newUser);
-
transaction.Commit();
-
session.Close();
- NHibernate
using NHibernate;
using NHibernate.Cfg;
-
Configuration cfg = new Configuration();
cfg.AddAssembly("NHibernate.Examples");
-
ISessionFactory factory = cfg.BuildSessionFactory();
ISession session = factory.OpenSession();
-
IList userList = session.CreateCriteria(typeof(User)).List();
-
session.Close();
-
foreach(User user in userList)
{
System.Diagnostics.Debug.WriteLine(user.Id + ":" +user.UserName +":"+ user.LastLogon);
}
- NHibernate
using NHibernate;
using NHibernate.Cfg;
-
Configuration cfg = new Configuration();
cfg.AddAssembly("NHibernate.Examples");
-
ISessionFactory factory = cfg.BuildSessionFactory();
ISession session = factory.OpenSession();
- LastLogon?
IList recentUsers = session.CreateCriteria(typeof(User))
.Add(Expression.Expression.Gt("LastLogon", new DateTime(2004, 03, 14, 20, 0, 0)))
.List();
-
session.Close();
-
foreach(User user in userList)
{
System.Diagnostics.Debug.WriteLine(user.Id + ":" +user.UserName +":"+ user.LastLogon);
}
- NHibernate
using NHibernate;
using NHibernate.Cfg;
-
Configuration cfg = new Configuration();
cfg.AddAssembly("NHibernate.Examples");
-
ISessionFactory factory = cfg.BuildSessionFactory();
ISession session = factory.OpenSession();
-
ITransaction transaction = session.BeginTransaction();
-
User joeCool = (User)session.Load(typeof(User), "joe_cool");
-
joeCool.LastLogon = DateTime.Now;
-
session.Flush();
-
transaction.Commit();
-
session.Close();
![[PukiWiki]](image/pukiwiki.png "[PukiWiki]")
