search

tmsmith / Dapper-Extensions

Dapper Extensions is a small library that complements Dapper by adding basic CRUD operations (Get, Insert, Update, Delete) for your POCOs. For more advanced querying scenarios, Dapper Extensions provides a predicate system. The goal of this library is to keep your POCOs pure by not requiring any attributes or base class inheritance.
1.79k stars 585 forks source link

Invalid table name（Oracle） #301

Open GitBySzl opened 2 years ago

GitBySzl commented 2 years ago

Hello! This is the database table： image

This is a POCO： image

"Invalid table name" kept coming back when inserting.

Solution. Thank you！

valfrid-ly commented 2 years ago

Is this the only table with this issue???

elvisveiga commented 2 years ago

@GitBySzl hello! I think that isn't possible. You are using Automap for TLSLT0X class in another class. image

aravindk777 commented 1 year ago

I am also receiving the error as "Table or view doesn't exist". For Oracle. Probably, a good detailed documentation about how to use DapperExtensions for Oracle (or any db) would help beginners to implement - would be helpful. I am having doubt as to how the schema name will be set or read.

valfrid-ly commented 1 year ago

@aravindk777, tables are declared "SCHEMA_NAME"."TABLE_NAME".

Lets remember that Oracle IS case sensitive. If you declare a table name "test" and another one as TEST they will be different.

Usually people forget that as they don't use "" in the names, but with "" you can even use spaces in the names.

Did you check if it's not a case issue???