Get Sqlite database tables via a `DbContext` object #dotnet #csharp

GetDatabaseTables.cs

	public static Dictionary<string, string> GetDatabaseTables(DbContext db)
	{
		Dictionary<string, string> tablesDictionary = [];
		var connection = db.Database.GetDbConnection();
		using var command = connection.CreateCommand();
		command.CommandText = "SELECT name, sql from sqlite_schema where type='table';";
		using var reader = command.ExecuteReader();
		while (reader.Read())
		{
			var entityName = reader.GetString(0);
			var createSql = reader.IsDBNull(0) ? string.Empty : reader.GetString(1);
			tablesDictionary[entityName] = createSql;
			Debug.WriteLine($"{entityName}: {createSql}");
		}

		return tablesDictionary;
	}