Insert with default values

[imalliar]

When the table has only identity and computed columns the correct format of the insert statement is:
INSERT INTO table_name DEFAULT VALUES.
Instead, the code generated by SqlGenerator is:
INSERT INTO table_name which is incorrect.
Is there any workaround?
Thanks in advance

[Yoinbol]

Hi, yes. You can override the Insert function on the given repository and inject there your statement (but only if you are using this package in conjunction with Dapper.DataRepositories).
Lets say your table is called "Persons" so I'm guessing you have a "PersonsRepository". What you can do is:

public override bool Insert(Person instance) {
return this.Connection.Execute("INSERT INTO Persons DEFAULT VALUES", new {}) > 0;
}

Now, if you are not using Dapper.DataRepositories what we can do is create an attribute called "DefaultValues" or something like that to decorate your class and append the "DEFAULT VALUES" statement to the end of the generated statement.