static MeasuredParameter[] GetMeasuredParameters() { MeasuredParameter[] measuredParameters = new MeasuredParameter[0]; using (var connection = new NpgsqlConnection(ConnectionString)) { connection.Open(); measuredParameters = connection.Query <MeasuredParameter>("SELECT \"Id\", \"OceanusCode\", \"OceanusCoefficient\" FROM public.\"MeasuredParameter\";").ToArray(); connection.Close(); } return(measuredParameters.ToArray()); }