Fluent-NHibernate table mapping with no primary key

fluent-nhibernate

I am trying to create a mapping to a database table that has no primary keys/references.

public class TestMap : ClassMap<<Test>Test> {

    public TestMap() {

        WithTable("TestTable");

        Map(x => x.TestColumn);

    }

}

This fails and expects id or composite-id. Is this possible in fluent nhibernate?

Best Answer

In Oracle at least, I have used "ROWID" for this. For mssql you might use the "ROW_NUMBER()" builtin function for readonly access to the table, but I haven't tried that...

Related Topic