search

Servant-Software-LLC / FileBased.DataProviders

ADO.NET & EF Core Data Providers for common serializable formats (JSON, XML, and CSV) stored to disk.
2 stars 1 forks source link

Providers to allow for quering a list of tables #26

Closed DaveRMaltby closed 1 year ago

DaveRMaltby commented 1 year ago

Following the SQL-92 standard, we should implement INFORMATION_SCHEMA.TABLES, which is a metadata view which lists all of the tables in the current database. Although the standard does not specify an exact schema for this metadata table, we will just follow the example of SQL Server and use their version of INFORMATION_SCHEMA.TABLES as a guidline.

Here is an example of quering this table: image

This task is needed to fulfill the need of our EFCore.FileBased.Providers to be able to implement RelationalDatabaseCreator.HasTables method.

DaveRMaltby commented 1 year ago

Added in commit https://github.com/Servant-Software-LLC/ADO.NET.FileBased.DataProviders/commit/8bb03d638610f37b780e5850f4e25d987233c06f

The unit test that will be called by RelationalDatabaseCreator.HasTables is called ExecuteScalar_ShouldCountSchemaTableRecords