Using SqlBuilder.SET

[skarm61]

Does DbExtension support Mysql? I use it with mysql and got some issues when i update records using

... .SET(field_name, value) ...

I get query like:

...
SET field_name, field_name
WHERE ...

except

SET field_name = @p0, field_name = @p1

Can you help me?

[maxtoroq]

The first parameter of the SET method is a format string. That means you have to do this:

...
.SET("field_name = {0}", value)

If you are getting the field name from a variable then you can do this:

...
.SET(field_name + " = {0}", value)

[skarm61]

Thanks for answer. It was my fail. In previous project I used it like

.SET("field_name = {0}", value)

And now, when i start to use properties and attributes to autogenerate update and insert queries, I made this mistake. I should use

.SET(field_name + " = {0}", value)

But it could be cool if you add one more method SET, which will receive property and value.

[maxtoroq]

You can extend SqlBuilder using extension methods. My intention is to keep is simple and consistent.