Cannot insert an object when the primary key is a string

[LeifUK]

I am using PetaPoco.NetCore.

The following does not work:

 _database.Insert("tblConfiguration", "name", configuration);

_database is an instance of PetaPoco.NetCore.Database. The table is created as follows:

_database.Execute("CREATE TABLE tblConfiguration (name VARCHAR(100) NOT NULL PRIMARY KEY, value VARCHAR(767) NOT NULL);");

I have to do this instead:

            string sql = "INSERT INTO tblConfiguration (name, value) VALUES (@0, @1);";
            _database.Execute(sql, configuration.name, configuration.value);

This works fine with the .Net version of PetaPoco.

[iadaz]

It sounds like you're using the fork of PetaPoco from https://github.com/qingask/PetaPoco.NetCore

The PetaPoco Nuget package that supports .net core is PetaPoco.Compiled: https://github.com/CollaboratingPlatypus/PetaPoco/wiki/V6NetStandard2-0

I'm afraid I can't tell you what breaking changes might exist between the latest PP and the fork.

[asherber]

@LeifUK I agree with @iadaz, but can you tell us what error you're getting?

Also, you can wrap your Insert() statement in a try..catch block in order to trap the exception, and in the catch you can examine _database.LastCommand to see what SQL was executed. This will help identify what the problem is.

If I had to guess, I'd say that your POCO class defines Name as the primary key but doesn't specify AutoIncrement=false. This makes PetaPoco think that the value for Name will be generated by the database, so it doesn't include that field in the SQL qhen you do Insert().