Dapper | Dommel | Oracle | Invalid table name

Question

Dapper | Dommel | Oracle | Invalid table name

premboyapati opened this issue 4 years ago · 11 comments

Hi there,

I am trying to get a simple select query from oracle database as shown in the below screenshot. It is not working for me, throwing an error, invalid table name. I am 100% sure there is no issue with my table and schema name and column mappings. It seems Dapper/Dommel is causing some issue in generating the sql with correct table name.

May I know how can I see what SQL query my get statement generating...by enabling logging or some way...

My DBA's will not allow SQL Profilers to see the query...

Error and Code:

In case if you are looking for stack trace:
at OracleInternal.ServiceObjects.OracleConnectionImpl.VerifyExecution(Int32& cursorId, Boolean bThrowArrayBindRelatedErrors, SqlStatementType sqlStatementType, Int32 arrayBindCount, OracleException& exceptionForArrayBindDML, Boolean& hasMoreRowsInDB, Boolean bFirstIterationDone)
at OracleInternal.ServiceObjects.OracleCommandImpl.ExecuteReader(String commandText, OracleParameterCollection paramColl, CommandType commandType, OracleConnectionImpl connectionImpl, OracleDataReaderImpl& rdrImpl, Int32 longFetchSize, Int64 clientInitialLOBFS, OracleDependencyImpl orclDependencyImpl, Int64[] scnForExecution, Int64[]& scnFromExecution, OracleParameterCollection& bindByPositionParamColl, Boolean& bBindParamPresent, Int64& internalInitialLOBFS, OracleException& exceptionForArrayBindDML, OracleConnection connection, OracleLogicalTransaction& oracleLogicalTransaction, IEnumerable1 adrianParsedStmt, Boolean isDescribeOnly, Boolean isFromEF) at Oracle.ManagedDataAccess.Client.OracleCommand.ExecuteReader(Boolean requery, Boolean fillRequest, CommandBehavior behavior) at Oracle.ManagedDataAccess.Client.OracleCommand.ExecuteDbDataReader(CommandBehavior behavior) at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior) **_at Dapper.SqlMapper.ExecuteReaderWithFlagsFallback(IDbCommand cmd, Boolean wasClosed, CommandBehavior behavior) at Dapper.SqlMapper.QueryRowImpl[T](IDbConnection cnn, Row row, CommandDefinition& command, Type effectiveType) at Dapper.SqlMapper.QueryFirstOrDefault[T](IDbConnection cnn, String sql, Object param, IDbTransaction transaction, Nullable1 commandTimeout, Nullable`1 commandType)
at Dommel.DommelMapper.Get[TEntity](IDbConnection connection, Object id, IDbTransaction transaction)_**

I would really appreciate your quick response...

Thank you,
Prem.

Answer 1 · 2020-06-17T19:33:05.000Z

I deep dive into the code and found the root cause. Dommel is assuming for some reason, my connection is to SQL server and generating the query to work with SQL server as in below:

select * from [SchemaNAME].[TableNAME] where [Id] = @id

This is method generating sql incorrectly as if I am trying to work with SQL server.......

Answer 2 · 2020-06-17T19:36:51.000Z

My connection is with SqlServer and I still have the same error

Answer 3 · 2020-06-17T19:42:51.000Z

The error that it generates in a project using SqlServer is this ..

Message: Não foi possível carregar o tipo IColumnNameResolver do assembly Dommel, Version=2.0.0.0, Culture=neutral, PublicKeyToken=null.

StackTrace: Dapper.FluentMap.Dommel.FluentMapConfigurationExtensions.ForDommel(FluentMapConfiguration config)
em xFidelidade.Data.RegisterMappings.<>c.b__0_0(FluentMapConfiguration config) em D:\Dados\Projetos\xFidelidade\src\xFidelidade.Data\RegisterMappings.cs:linha 19
em Dapper.FluentMap.FluentMapper.Initialize(Action1 configure) em xFidelidade.Data.RegisterMappings.Register() em D:\Dados\Projetos\xFidelidade\src\xFidelidade.Data\RegisterMappings.cs:linha 13 em xFidelidade.Data.Repository.Repository1..ctor(IDbConnection connection) em D:\Dados\Projetos\xFidelidade\src\xFidelidade.Data\Repository\Repository.cs:linha 18
em xFidelidade.Data.Repository.CategoriaClienteRepository..ctor(IDbConnection connection) em D:\Dados\Projetos\xFidelidade\src\xFidelidade.Data\Repository\CategoriaClienteRepository.cs:linha 13
em xFidelidade.CategoriaCliente.frmCategoriaCliente.frmCategoriaCliente_Load(Object sender, EventArgs e) em D:\Dados\Projetos\xFidelidade\src\xFidelidade\CategoriaCliente\frmCategoriaCliente.cs:linha 26
em System.Windows.Forms.Form.OnLoad(EventArgs e)
em System.Windows.Forms.Form.OnCreateControl()
em System.Windows.Forms.Control.CreateControl(Boolean fIgnoreVisible)
em System.Windows.Forms.Control.CreateControl()
em System.Windows.Forms.Control.WmShowWindow(Message& m)
em System.Windows.Forms.Control.WndProc(Message& m)
em System.Windows.Forms.ScrollableControl.WndProc(Message& m)
em System.Windows.Forms.Form.WmShowWindow(Message& m)
em System.Windows.Forms.Form.WndProc(Message& m)
em System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)
em System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
em System.Windows.Forms.NativeWindow.DebuggableCallback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)

Answer 4 · 2020-06-17T19:43:04.000Z

My connection is with SqlServer and I still have the same error

Did you check your model with correct attributes...your model class should be like this....

Good luck! Let me know if it works for you.

Answer 5 · 2020-06-17T19:46:48.000Z

My map is like this, I use FluentMap

Answer 6 · 2020-06-17T19:49:08.000Z

My map is like this, I use FluentMap

I tried like you intitially but not working...comment your mapping code and decorate your model using Table and Column attributes...That's why you are getting 'IColumnNameResolver

Answer 7 · 2020-06-17T20:46:11.000Z

Meu mapa é assim, eu uso o FluentMap

Tentei como você inicialmente, mas não está funcionando ... comente seu código de mapeamento e decore seu modelo usando os atributos Tabela e Coluna ... É por isso que você está recebendo 'IColumnNameResolver

When I change the model by inserting the annotations in it, it works correctly.
I'm sorry, I'm still learning to use this type of technology, but is this a mistake and will it be corrected? or will it continue like this?
I like to use FluentMap, because I don't make my models "dirty"

Answer 8 · 2020-06-17T21:26:56.000Z

Meu mapa é assim, eu uso o FluentMap

Tentei como você inicialmente, mas não está funcionando ... comente seu código de mapeamento e decore seu modelo usando os atributos Tabela e Coluna ... É por isso que você está recebendo 'IColumnNameResolver

When I change the model by inserting the annotations in it, it works correctly.
I'm sorry, I'm still learning to use this type of technology, but is this a mistake and will it be corrected? or will it continue like this?
I like to use FluentMap, because I don't make my models "dirty"

I am not an author of this code base. I do not know if this is an issue or not. With my experience, I would say there is huge GAP between what documentation says and what codebase works...

I will leave your question to answer the codebase owner/stakeholder...

I am glad to hear that my suggestion worked for you...whenever you think something worked, please give thumbs up, so that others can quickly look at it and try that same solution.

Good luck again!

Answer 9 · 2020-06-17T21:30:47.000Z

Hi there,

Do you guys know these basic issues exists in the code...It's only working with the property based column attribute and not working with fluent mapping....

Does this codebase works with Oracle database? If yes, Can you point me to the documentation.
If no, Do I need to implement any interface to work with oracle? How can I do that?

Thanks
Prem.

Answer 10 · 2020-07-17T12:53:59.000Z

Dapper.FluentMap.Json does not work with Dommel v2 yet, but there is a PR in progress: henkmollema/Dapper-FluentMap#105

As for Oracle support, you should implement a custom ISqlBuilder for Oracle (e.g. OracleSqlBuilder and add it with in your startup code:

DommelMapper.AddSqlBuilder(typeof(OracleConnection), new OracleSqlBuilder());

Answer 11 · 2020-08-23T10:01:25.000Z

Dapper.FluentMap.Dommel v2 is released.