An error of PostgreSQL select request

[dimminbox]

Hello.

When I was using this library to exchange data with MySQL there were no problems, but later i supposed to change Mysql to PostgreSQL and one problem was shown.

This peace of a code:

var queryResult = SqlGenerator.GetSelectAll(expression, null);
sql = queryResult.GetSql();
resultGet =
	await Repository.Connection
		.QueryAsync<T>(new CommandDefinition(sql, queryResult.Param)); 

where Shipment Poco model is:

namespace Shipment.Core.Model
{
    public class Shipment : Base
    {
        public string Guid { get; set; }
        
        public string Contractor { get; set; }
        
        public DateTime Date {
            get;
            set;
        }
}

and a sql variable has a value:

SELECT Shipment.Id, Shipment.Guid, Shipment.Contractor, Shipment.Date FROM Shipment WHERE Shipment.Guid = ANY(@Guid_p0)

In fact, all of these generates an exception:

Npgsql.PostgresException (0x80004005): 42P01: relation "shipment" doesn't exist

POSITION: 730
   at Npgsql.Internal.NpgsqlConnector.ReadMessageLong(Boolean async, DataRowLoadingMode dataRowLoadingMode, Boolean readingNotifications, Boolean isReadingPrependedMessage)
   at System.Runtime.CompilerServices.PoolingAsyncValueTaskMethodBuilder`1.StateMachineBox`1.System.Threading.Tasks.Sources.IValueTaskSource<TResult>.GetResult(Int16 token)
   at Npgsql.NpgsqlDataReader.NextResult(Boolean async, Boolean isConsuming, CancellationToken cancellationToken)
   at Npgsql.NpgsqlDataReader.NextResult(Boolean async, Boolean isConsuming, CancellationToken cancellationToken)
   at Npgsql.NpgsqlCommand.ExecuteReader(Boolean async, CommandBehavior behavior, CancellationToken cancellationToken)
   at Npgsql.NpgsqlCommand.ExecuteReader(Boolean async, CommandBehavior behavior, CancellationToken cancellationToken)
   at Npgsql.NpgsqlCommand.ExecuteDbDataReaderAsync(CommandBehavior behavior, CancellationToken cancellationToken)
   at Dapper.SqlMapper.QueryAsync[T](IDbConnection cnn, Type effectiveType, CommandDefinition command) in /_/Dapper/SqlMapper.Async.cs:line 434
   at Shipment.Core.Repository.RepositoryBase`1.ListAsync(IEnumerable`1 filter, IEnumerable`1 sort)

Because of shipment poco model doesn't contain Table attribute with value [Table(""Shipment"")]

I think the root of the problem is library properly build a sql text for PostgreSQL without consideration double-comma. Unfortunately, it doesn't work automatically and that's why i must add attributes in all poco models.

Is there any way to solve it? If there is no solution but pointing attributes, i can suggest some enhancement to avoid this embarrassing one.

Thanks.

[phnx47]

@dimminbox What about UseQuotationMarks?

[dimminbox]

Thanks, it looks like a remedy.