search

sqlkata / querybuilder

SQL query builder, written in c#, helps you build complex queries easily, supports SqlServer, MySql, PostgreSql, Oracle, Sqlite and Firebird
https://sqlkata.com
MIT License
3.08k stars 498 forks source link

Insert/Update a geometry field #651

Closed bad-ch closed 1 year ago

bad-ch commented 1 year ago

Is there already a way to use such constructs <<< geometry::STGeomFromText('POINT(2702172.391 1268000.746)', 0) >>> for an update or an insert. UnsafeLiteral is not usable for this case.

bad-ch commented 1 year ago

I found the solution, with Expressions.UnsafeLiteral("", false) you could use the expression above in the update/insert object