Chapter 12: Creating a class library for entity models using SQLite' help needed.

[Jammerref2015]

In chapter 12. I am trying to follow the 'Creating a class library for entity models using SQLite'. I follow the 10 steps but I am not getting any Classes generated. I have NorthwindContext.cs created. Am I doing something wrong? Missing a step? I have the DB connected, I can see the data in SQLite/SQLserver Compact Toolbox.

[markjprice]

Mostly likely the dotnet-ef tool cannot find the database file in the location specified. If the database file is missing, then the SQLite database provider will create an empty database file and since it is empty, you get a DbContext class generated but not any entity model classes.

If you are doing Chapter 12, then you would have had to run the dotnet-ef tool in Chapter 10 on page 453 as well. Did you get it to work then? What are you doing differently this time? Are you in the correct folder when you enter the command? Does the command use the correct relative path to the database file?

[Jammerref2015]

Yup That was it. Sorted now. Thanks. :-)

[Jammerref2015]

I am getting red lines now. For Index and Name in each of the class files..

Switching from [Index("CategoryName", Name = "CategoryName")] to [Microsoft.EntityFrameworkCore.Index("LastName", Name = "LastName")] removes them. Is this ok?

[markjprice]

Yes, that's fine, but you shouldn't need to specify the fullname namespace before the class name for the Index attribute. It's namespace should have been imported like line 5 here:
https://github.com/markjprice/cs11dotnet7/blob/main/vs4win/PracticalApps/Northwind.Common.EntityModels.Sqlite/Category.cs#L5