Connecting nhibernate to Postgresql in C#

Question

This is my first time working with nhibernate and I'm experiencing problems connecting and retrieving data from a Postgresql database. The code doesn't give an error, but returns no values either. When I use pgAdmin3 I do get data.

AutoPersistenceModel model = AutoMap.Assembly(System.Reflection.Assembly.GetCallingAssembly())
    .Where(t => t.Namespace == "POCPostgresql.Model");

var configuration = Fluently.Configure()
    .Database(PostgreSQLConfiguration.Standard
    .ConnectionString(c => c
        .Host("server")
        .Port(5432)
        .Database("database")
        .Username("username")
        .Password("password")))
    .Mappings(m => m
        .AutoMappings.Add(model))
    .ExposeConfiguration(config => new SchemaExport(config).Create(false, true))
    .BuildSessionFactory();

    using (var session = configuration.OpenSession())
    {
        // Query all objects
        var completeList = session.CreateCriteria<Object>().List();

        Console.ReadLine();
    }

The completelist variable is an empty list.

Is there anything I'm forgetting?

Edit: Also when moving the configuration to the app.config and initializing it differently results in an empty list

Configuration configuration = new Configuration();
configuration.Configure();
ApplicationCore.Instance.SessionFactory = configuration.BuildSessionFactory();

using (var session = ApplicationCore.Instance.SessionFactory.OpenSession())
{
    var completeList = session.CreateCriteria<Object>().List();

    Console.ReadLine();
}

Edit 2: I thought maybe it was the server that denies my query for some reason but I've tried querying using only npgsql, this is working fine.

NpgsqlConnection conn = new NpgsqlConnection("server=server;Port=5432;Database=database;User Id=username;Password=password;");
conn.Open();
string sql = "SELECT * FROM report LIMIT 100";

NpgsqlCommand command = new NpgsqlCommand(sql, conn);

NpgsqlDataReader dr = command.ExecuteReader();

while (dr.Read())
    Console.Write("{0}\t{1} \n", dr[0], dr[1]);

conn.Close();

Console.ReadLine();

Mark · Accepted Answer · 2015-09-17 13:38:24Z

3

I've fixed this problem by changing the mapping to use fluent mappings and everything suddenly worked

.Mappings(m => m.FluentMappings.AddFromAssemblyOf<ReportDB>())

answered Sep 17, 2015 at 13:38

Mark

3,2714 gold badges34 silver badges57 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Radim Köhler · Accepted Answer · 2015-09-03 10:16:33Z

0

The point here (I can see) is in the wrong type passed into query:

var completeList = session.CreateCriteria<Object>().List();

As we can see, we ask for Object (passed as <TEntity>) which is the C# built in type and almost for sure NOT MAPPED by NHibernate mapping...

NOTE: The not-so-nice side of NHibernate is - when querying not mapped object - we get empty result instead of error

So, just try to ask for some really mapped object:

var completeList = session.CreateCriteria<Employee>().List();

answered Sep 3, 2015 at 10:16

Radim Köhler

124k48 gold badges243 silver badges343 bronze badges

Collectives™ on Stack Overflow

Connecting nhibernate to Postgresql in C#

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related