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 Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider