I am new to Hibernate world. It may be a silly question, but I am not able to solve it. I am testing many to One relationship of tables and trying to insert record. I have a Department table and Employee table. Employee and Dept has many to One relationship here. I am using Fluent NHibernate to add records. All codes below. Pls help

- SQL Code

create table Dept ( Id int primary key identity, DeptName varchar(20), DeptLocation varchar(20)) create table Employee ( Id int primary key identity, EmpName varchar(20),EmpAge int, DeptId int references Dept(Id))

Class Files

public partial class Dept {

  public virtual System.String

DeptLocation { get; set; }

  public virtual System.String

DeptName { get; set; }

  public virtual System.Int32 Id {

get; private set; }

    public virtual IList<Employee> Employees { get; set; }         }

public partial class Employee { public virtual System.Int32 DeptId { get; set; }

  public virtual System.Int32 EmpAge {

get; set; }

  public virtual System.String EmpName

{ get; set; }

  public virtual System.Int32 Id {

get; private set; }

  public virtual Project.Model.Dept 

Dept { get; set; } }

Mapping Files

public class DeptMapping : ClassMap
{ public DeptMapping() { Id(x => x.Id); Map(x => x.DeptName); Map(x => x.DeptLocation); HasMany(x => x.Employees) .Inverse() .Cascade.All(); } }

public class EmployeeMapping : ClassMap { public EmployeeMapping() { Id(x => x.Id); Map(x => x.EmpName); Map(x => x.EmpAge); Map(x => x.DeptId); References(x => x.Dept) .Cascade.None(); } }

My Code to add

try { Dept dept = new Dept(); dept.DeptLocation = "Austin"; dept.DeptName = "Store";

            Employee emp = new Employee();
            emp.EmpName = "Ron";
            emp.EmpAge = 30;

            IList<Employee> empList = new List<Employee>();
            empList.Add(emp);
            dept.Employees = empList;
            emp.Dept = dept;

            IRepository<Dept> rDept = new Repository<Dept>();
            rDept.SaveOrUpdate(dept);
        }
        catch (Exception ex)
        {
            Console.WriteLine(ex.Message);
        }

Here i am getting error as InnerException = {"Invalid column name 'Dept_id'."}

Message = "could not insert: [Project.Model.Employee][SQL: INSERT INTO [Employee] (EmpName, EmpAge, DeptId, Dept_id) VALUES (?, ?, ?, ?); select SCOPE_IDENTITY()]"