LINQ GroupBy error (Postgres)

Hi!

LINQ code 

var query = from l in db.Logs group l by l.OwnerId into g select g;

foreach (var logGrupa in query)

{
	foreach(var log in logGrupa)
        {
        	logs.Add(log);
        }
}

SELECT
  g1.OwnerId
FROM
  (
    SELECT
      logs_bhr.OwnerId AS "OwnerId"
    FROM
      logs_bhr logs_bhr
    WHERE
      logs_bhr.DeletedOn IS NULL
    GROUP BY
      logs_bhr.OwnerId
  )
  g1

ERROR:  column g1.ownerid does not exist

Postgres is expecting a lower cased name to be used you will need to use a custom naming strategy to ensure this is the case when any quoting is required.

What you will want to look at doing is to implement a custom naming strategy (have a look at this thread for an example: http://www.mindscape.co.nz/forums/Thread.aspx?PostID=8667)

You will want to force lower cased column names like so:

public string GetColumnName(string defaultName, string fieldName)

{

  return defaultName.ToLower();

}

Jeremy