So I want to get a list of all the table names from the database through a controller as an ASP.net API project. I tried to do it through raw sql query without entity and it looked something like this. But when I try to use the SqlQuery method I get the error ” ‘DatabaseFacade’ does not contain a definition
Tag: rawsql
Sequelize raw query update array of objects as replacements
I am using sequelize (postgres) and I need to properly escape a query like this: Sample input.pets: Does anyone have an idea how to achieve this with replacements? I have found a thread on github which suggested something like this: However, a 2d array is being used here not an array of objects. Is there a way to access individual
`?` placeholder for SQL `IN` condition with persistent’s `rawSql`
I would be happy to use ? placeholder to populate ids for SQL IN clause. Unfortunately the following does not work Such code results in database error similar to: Wrapping ? placeholder with brackets (e.g. IN (?)) gives another type of error: Is there a way to accomplish this? P.S. Looks like it’s a horrible title, have no idea how