(Simplifying:) I am creating a module that is a book catalog.

In SQL Server I have 3 tables to store this book catalog.
If every book has just 1 author I could suffice with just 1 table. But there are books that have multiple authors.
The 3 tables in SQL Server look like this.

The first table (BookDetails) has the following fields:
BookID (int)
YearOfPublishing (int)
Title (nvarchar)

The second table (Authors) has the following fields:
AuthorID (int)
FirstName (nvarchar)
LastName (nvarchar)

The third table links the first 2 tables and has the fields:
ID (int)
ArticleID (int)
AuthorID (int)

In DotNetNuke I created a BookInfo class with arrays of string as data types for the FirstName and LastName properties.
This to be able to store multiple authors for 1 book.
So the BookInfo class has the following properties:
YearOfPublishing as Integer
Title as String
FirstName() as String
LastName() as String

How do I tie this all up within the IHydratable Fill method?
Can it be done or should I use another approach?
Help much appreciated.

A few recommendations here.

1.) I would change your structure a bit and create an "Author" class, to hold the AuthorId, FirstName, and Last Name value

2.) I would then change your BookInfo object to have a "List<Of AuthorInfo>" for the authors.

What you can then do is in your iHyrdratable method, you can call out to the database, and fill the list of authors using the same methods.

__________________
Mitchel Sellers
Microsoft C# MVP, MCITP
Director of Development
IowaComputerGurus Inc.

My blog for .NET and DotNetNuke info

Author of "Professional DotNetNuke Module Programming"

Tech Editor on "Visual Studio 2010 six-in-one" and "Pro C# 4.0"

Thanks for your reply.
The 1st and 2nd step are clear to me.

Only the last part I don't yet have a clear picture of. Could you may be make it a bit more explicit, may be with a few lines of example code?