FbConnection.GetSchema getting column information does not bring the
column_size on varchar columns
---------------------------------------------------------------------------------------------------
Key: DNET-861
URL: http://tracker.firebirdsql.org/browse/DNET-861
Project: .NET Data provider
Issue Type: Bug
Components: ADO.NET Provider
Affects Versions: 6.4.0.0, 6.3.0.0
Environment: Visual Studio 2017
ASP.NET Core
NET Standard libraries
Reporter: Fabricio Araujo
Assignee: Jiri Cincura
I have my own way to generate SQL to use with Dapper (Dapper.Contrib does not
fit well
in what I'm doing) and I need to get column information to do so.
When I'm working with database tables directly, all works wonders when I use
this call:
DataTable dtb = conn.GetSchema("COLUMNS", new string[] { null, null,
ParamTableName });
When I use a view, things gets weird. Views (is not a trivial view, it has a
few joins) with varchar columns comes with COLUMN_TYPE correct but COLUMN_SIZE
comes NULL.
I traced the executed SQL of GetSchema but while it does not bring the type of
the column (only the reference to the domain) it DOES BRING
the COLUMN_SIZE correctly
The other columns comes correctly (all those are INTEGER columns though).
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://tracker.firebirdsql.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
_______________________________________________
Firebird-net-provider mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
