executequery
PostgreSQL EXECUTE command success but no change in table
I have the following PostgreSQL script: CREATE OR REPLACE FUNCTION merge_fields() RETURNS VOID AS $$ DECLARE[详细]
2023-04-02 09:20 分类:问答Why does Linq need a setter for a 'read-only' object property?
I\'m using a Linq DataContext.ExecuteQuery(\"some sql statement\") to populate a list of objects var incomes = db.ExecuteQuery<IncomeAggregate>(sqlIncomeStatement(TimeUnit));[详细]
2023-03-21 17:40 分类:问答Unexpected SQL results: string vs. direct SQL
Working SQL The following code works as expected, returning two columns of data (a row number and a valid value):[详细]
2023-03-09 05:01 分类:问答executeQuery taking six times as long to run as opposed to when query is run in TOAD
I inherited a...well, I guess I can call it a piece-of-#### Struts application, and am tasked with optimizing a Levey-Jennings process that checks if our quality control standards are up to snuff.[详细]
2023-02-28 02:25 分类:问答Using ExecuteQuery() with entity framework, entity class
I am trying to jump from ASP Classic to asp.net. I have followed tutorials to get Entity Framework and LINQ to connect to my test database, but I am having difficulties figuring out ExecuteQuery(). I[详细]
2023-02-04 19:45 分类:问答executing a reference to field.onchange in Firefox
I have HTML code which calls a javascript function from a form, using: <form name=\"f\" id=\"f\" ...>[详细]
2023-01-13 18:10 分类:问答In maven, how can I execute a SQL if I detect the table structure is missing?
I\'m modifying an existing maven2 project and I would like to create the database structure if I notice it is missing.[详细]
2023-01-10 17:09 分类:问答Is it possible to return multiple result sets using ExecuteQuery in Linq to Sql?
I know that you can return multiple results from a stored procedure and through the method generated by the designer.[详细]
2023-01-08 11:54 分类:问答Can ExecuteQuery return a DBML generated class without having it fetch all the information for that class?
I have a couple of DBML generated classes which are linked together by an id, e.g. ClassA { AID, XID, Name[详细]
2023-01-06 01:22 分类:问答Calling stored proc with LINQ .ExecuteQuery to return non-mapped fields
I have a stored procedure which returns all the fields of a table plus one, ie: tablename.*,count(suchandsuch)[详细]
2023-01-05 09:28 分类:问答