Query Firebird database schema with FirebirdClient

Question

How can I query database schema in C#/ADO.NET/FirebirdClient? All classes in namespace Firebird.Data.Schema are internal.

For example: check if table has column with specified name query number of stored procedure parameters, its names and types

etc.

FirebirdClient - Compact Framework, NETProvider-2.5.2-CF.7z

Dennis · Accepted Answer · 2013-05-16 07:25:43Z

3

You should query system tables (their names are prefixed with RDB$):

How to get a list of tables, views and columns in Firebird database?
RDB$ system objects

answered May 16, 2013 at 7:25

Dennis

37.9k11 gold badges87 silver badges158 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

hellboy Over a year ago

I mean is there possible to use internal classes of FirebirdClient in my application. The code to query RDB$ tables is presented in this library and rewrite it twice is IMHO not very good idea

Dennis Over a year ago

You may use any internal type via reflection, so, this is possible. Although, you should remember, that internal types usually are not documented, and their contract could be broken even between two releases. Also, you could ask FB client developer about making these types public. May be, there're some reasons, which prevents him to do this.

hellboy · Accepted Answer · 2013-05-16 08:09:38Z

1

I' ve got it!

    FbConnection connection = (FbConnection)this.GetConnection();
    connection.GetSchema("procedureparameters", new string[] { null, null, procedureName });

Also it possible to retrieve all information about database objects with FbConnection ::GetSchema

See also FbSchemaFactory::PrepareCollection

answered May 16, 2013 at 8:09

hellboy

1,6286 gold badges23 silver badges58 bronze badges

3 Comments

user153923 Over a year ago

Very cool! I'd be interested in learning what you're doing with it, too.

user153923 Over a year ago

(hopefully, not snooping on your wife)

hellboy Over a year ago

There is issue with Compact Framework: in FirebirdClient there is no FirebirdSql.Schema.FbMetaData.xml included (as embedded resource)

Collectives™ on Stack Overflow

Query Firebird database schema with FirebirdClient

2 Answers 2

2 Comments

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related