Question: How to return Composite Primary Key in InsertAsync?

[biapar]

I've a generic SaveAsync

public virtual async Task<TReturn> SaveAsync<TReturn>(TEntity entity)
        {
            using ( var connection = GetConnection() )
            {
                return await connection.InsertAsync<TEntity, TReturn>(entity);
            }
        }

Called :

await MatrixAddonManager.SaveAsync<int>(MatrixAddon)

How to return a primary field that correspond to a composite primary key?

Thanks

[mikependon]

@biapar - it is unfortunate, the composite keys are not supported with RepoDB. It is also a part of our limitation page.

[biapar]

I by passed using this code

SaveAsync<object>

[mikependon]

Does it work? Pretty sure RepoDB could not handle the generated ID of composite keys. 😄

[biapar]

Works. It give me only the first field of the key. I'll tried again.

[biapar]

I've the composite key

         modelBuilder.Entity<Sample>()
                .HasKey(c => new { c.Data, c.Lotto, c.Barcode });

and the insert return me the first field of the table because I tried also with other table with other composite field and give me the first field of the table.

[mikependon]

Was not it a problem in your case? It should somehow return you the values of the composite fields (more than 1 field).
RepoDB is not handling multiple composite values (from composite keys) - IMO

[biapar]

Not in my case for this tables, for others yes, but it's important that the row will be saved. For me is not important to get the key of the insert because I know it and the 90% of time I try to not use the identity key.