There is one Author Table, one Book table and one Author and Book table.

Author table

public class Author

$\{$

public int AuthorID $\{$ get; set; $\}$

public string Name $\{$ get; set; $\}$

public string Surname $\{$ get; set; $\}$

public ICollection AuthorandBooks $\{$ get; set; $\}$

$\}$

Book table:

public class Book

$\{$

public Guid BookID $\{$ get; set; $\}$

public string BookName $\{$ get; set; $\}$

public string BookType $\{$ get; set; $\}$

public DateTime PublicationDate $\{$ get; set; $\}$

$\}$

Now our $3$rd table will bring AuthorID and BookID.

e$.$g$.$

AuthorID $|$ BookID

$---------------------------$

$01|2838984$

$02|2839838$

There will be $1$ million book data, like book$0$ book$1,$ and we will return it with the web api.

I set up the architecture, created the classes, but I could not load data by opening a console application. I couldn't create the controller and I couldn't create the part where I wanted it to fetch a table. Please help me$.$