PetaPoco | Official PetaPoco , A tiny ORM-ish thing for your POCO | Object-Relational Mapping library

I am trying to use petapoco with my .NET core MVC application, I have installed petapoco compiled as stated in another answer but don't know what to do next, I searched many places but most of them had been using the previous versions of petapoco and not the latest one, Can someone please help and provide some resources link as to how am I supposed to connect it with my SQL server using a connection string, and since now their documentation suggested to use PetaPoco.DBEntityGenerator instead of T4 templates, I have no idea how to use it.

In .Net Framework 4.7.2 F#, I have been using:

I am using Npgsql 3.0.3.0 and PetaPoco latest version.

When I run this command:

I have N-Layer solution in .Net with PetaPoco as microORM. I get the entities generated from the template generator of PetaPoco. These entities T derive from the base class Record. Then I extend them adding more data access facilities and custom Save() and Delete() methods that override the Record default methods.

Following is the overrided Delete method from the entity (the method I want to call)

I am trying to make a method which takes in a variable object type as a parameter, and then updates a database depending on what object was passed, a bit like how Petapoco works for C#. For this I am trying to use a generic method in which the object that is passed passes a number of checks before it is inserted/updated into its relevant table. A number of questions on Stack Overflow point me towards using a method signature like this:

I am still relatively new to EF Core and beforehand I used PetaPoco, so please forgive my ignorance. In my database, I added the following fields to my AspNetUsers table:

• Elevated
• Deactivated
• FirstName
• LastName

I then created the following classes following this blog article:

I am using this example from Umbraco docs and when i try to save values to the database table i am getting this error: Cannot insert the value NULL into column 'Id', table 'petapoco.dbo.BlogComments'; column does not allow nulls. INSERT fails. The statement has been terminated.

Also, after table is created and i check it in database, I can see that primary key and autoincrement option is not set for id field.

And this is how i insert values:

PetaPoco PostgreSQL 11.1

I am attempting to get a list of deleted record id's. This does NOT work:

I use C#, SQL Server and PetaPoco which auto increments the ID by default. I just want to know that if it is possible to set this autoincremented id to another column.

I have 2 more columns needs to be set with the exact value of ID. Is it possible to do this inside the SQL CREATE TABLE statement or doing some hook before or after ExecuteNonQuery? I don't want to create a view or a trigger if it's possible.