How can I run a SQL query in C# statement/program with Linqpad?

Question

How can I run a SQL query in C# statement or C# program with Linqpad?

Yes I have to mix SQL statements with Linq for compatibility reason. I use linqpad with postgres driver and these driver doesn't recognize the hstore of postgres. I already knows I can get these ignored column by using classic SQL.

Answer 1

You can use the ExecuteCommand on LinqPad to run SQL statements direct on C# Statement. You can execute SQL statements with parameters formatting command string with {0}, {1}, etc.

ExecuteCommand("DELETE FROM TableOne where PrimaryKey = {0}", primaryKey);