automap | ️ | Performance Testing library

In these 3 classes, how do you map SourceString to DestinationString?

I have a database with a table named "items":

I have a next resultMap

I have a elasticsearch Nest Model class

Before anyone marks this question as a duplicate of Get _id of an inserted document in MongoDB? please read the whole question.

I am developing a ASP.NET Core API app with MongoDB driver.

The problem I am facing is that after inserting a document in the database the Id property of the Post class is not assigned the id generated by MongoDB.

I found few questions where they solved it using the annotations/attributes in the class but, I am developing a pattern where domain classes don't have any persistence knowledge.

I have created the entity class without annotations:

I have a code that works fine, but it looks too big as it has repetitive line of codes, can someone help me to make it shorter?

I have a single table called Tags that stores a "Tag" as a row, regardless of what specific subclass they represent. Some rows represent modbus tags, some snmp, some other protocols. All classes inheriting from Tag store their data in this one table, and unused columns simply contain null values.

At the moment, I have DAO methods like, getAllModBusTags() which contains an instruction mapToBean(ModBusTag.class). Eventually all of the subclasses of Tag are fetched from the database (one fetch per protocol) and then added to an ArrayList of the supertype Tag.

My question is, is there a simple means with Jdbi to perform conditional mapping of rows so that if a row contains a specific value, it is mapped to ModBusTag.class but if a row contains a different value it is mapped to SNMPTag.class, and so on and so forth?

My end goal is to have a single select statement that fetches every tag from the database, automaps to the correct bean on a row by row basis and then stores all of these subclass beans in a List of the supertype Tag.

Example Method for Single Type:

I'm using the example on https://www.elastic.co/guide/en/elasticsearch/client/net-api/current/custom-serialization.html#_serializing_type_information to get $type information for the documents in elasticsearch.

However as mentioned on the page this only returns type information for the outer document:

the type information is serialized for the outer MyDocument instance, but not for each MySubDocument instance in the SubDocuments collection.

So my question now is if anyone knows how to also get type information for sub documents?

I've tried using the same JsonSerializerSettings as in their example separate from Elasticsearch (using LinqPad) and there I get type information also for sub documents:

Using Nest, I have a function that sets up all the Elasticsearch document fields and analyzers/SearchAnalyzers.

One of the fields is a Nest Attachment object. This is used to attach a PDF so the content of the PDF can be indexed by Elasticsearch.

Running an "Analyze" Elasticsearch request on the Attachment field shows it is using a 'default' analyzer.

What I want to know is how do I specify a custom Analyzer for this Attachment field (thats auto mapped.)

I would like to map the Attachment.Content field to my analyzer called "literalNameSynonymsAnalyzer" as this is the field that holds the content of the PDF after its been parsed and converted to plain english text.