Dapper.SimpleCRUD | write basic read/insert/update/delete statements | DB Client library

This was old request raised here on GitHub:

A work around is to provide a TableAttribute on the class in this fashion:

[Table("Schema].[Table")]

The feature was included as stated here on GitHub:

See the tests: https://github.com/ericdc1/Dapper.SimpleCRUD/blob/master/Dapper.SimpleCRUDTests/Tests.cs#L83

I don't see any Dapper method for what you want to achieve. The only options are two single deletes and two multiple deletes.

You need to add attribute MultipleActiveResultSets in connection string and set it to true to allow multiple active result sets.

Have you had a look at the generated SQL? In stack trace may be? I guess it must be missing name of database table. Yes; I guess. Because I never used SimpleCRUD.

an object of any type that is in the db

How do SimpleCRUD know that the object you send in is "of type that is in the db"?

I think object type parameter is the problem. To accept "an object of any type that is in the db" you should consider converting your method to use generic type instead of object.

When I change my own Insert method to take a Menu-object instead of a general object, it works.

This confirms my earlier diagnosis.

Convert your method to something like below:

The whole .net CRUD thing is a big realm with a lot of flavors and ways of doing the work. And while I don't know exactly where you are at with this, the following my help out. In my experience EF can handle relationships quite well, though the whole EF learning process is a bit steep and I've shied away from it. I typically use Dapper with extensions and do stuff pseudo-manually. I haven't used the SimpleCrud extension. Since you inherited the DB, hopefully it's set up well and there's a FK constraint on Distribution, Column EntryID.

In Dapper, you could set up your classes like: