MVC5中使用PetaPoco搭配SQLite报错‘no user table found’如何解决？

Hey there, that error usually pops up because PetaPoco can't automatically map your model to the correct SQLite table name—let's walk through the straightforward ways to explicitly specify the table, plus some checks to make sure everything lines up.

1. Use the [TableName] Attribute on Your Model (Most Recommended) #

PetaPoco relies on conventions by default, but if your table name doesn't match the model class name (e.g., your model is User but the table is user instead of the default pluralized users), you can directly annotate the model to point to the right table:

using PetaPoco;

[TableName("user")] // Explicitly tells PetaPoco this model maps to the "user" table
[PrimaryKey("Id", autoIncrement = true)] // Optional but critical for SQLite auto-increment keys
public class User
{
    public int Id { get; set; }
    public string Username { get; set; }
    public string Email { get; set; }
}

This is the cleanest approach because it keeps your mapping logic tied directly to the model, so you don't have to repeat table names in every query.

2. Specify the Table Name Directly in Queries/Operations #

If you prefer not to use attributes, you can pass the table name directly when calling PetaPoco methods:

• For inserting data:

  var db = new Database("YourSQLiteConnectionString");
  var newUser = new User { Username = "jdoe", Email = "jdoe@example.com" };
  db.Insert("user", "Id", newUser); // First param = table name, second = primary key column
  

• For fetching data:

  var users = db.Query<User>("SELECT * FROM user");
  

3. Double-Check Your Table Creation SQL #

Make sure the table you're creating in your controller actually matches the name you're trying to reference. SQLite is case-insensitive, but it's better to keep names consistent to avoid confusion. For example, your table creation code should look like this:

db.Execute(@"CREATE TABLE IF NOT EXISTS user (
    Id INTEGER PRIMARY KEY AUTOINCREMENT,
    Username TEXT NOT NULL,
    Email TEXT NOT NULL
)");

If you accidentally created a table named users (plural) instead of user, that's definitely going to trigger the "no table found" error.

Quick Additional Checks #

• Verify your SQLite database file is being created in the right location (usually App_Data in MVC5). You can check this by opening the project folder in File Explorer.
• Ensure your connection string points to the correct file path. A typical SQLite connection string in Web.config looks like:

  <connectionStrings>
    <add name="SQLiteConnection" connectionString="Data Source=|DataDirectory|MyDatabase.db;Version=3;" providerName="System.Data.SQLite" />
  </connectionStrings>
  

By explicitly mapping your model to the correct table name (either via attributes or direct method calls), you should resolve that "no user table found" error and get your data displaying in the view.

内容的提问来源于stack exchange，提问作者vVvegetable