• These are called “parameterized queries” in .NET. It’s the best way to write queries as you don’t bother about how to send the data to the server (stuff like “how do I format my float values depending on the language of the SQL server and that of the .Net local culture?”). It allows the system to “cache” the structure of the query and just send the parameters.
    But I don’t think the gain is in INSERT statements, but rather in complex SELECTs with many JOINs that may not be on foreign keys.

  • Mihai

    Like Siderite, I’ve worked with the .NET version of the PHP “prepared statements”, also found it useful and came in handy every time.

  • Raul
  • Raul> are you turning to the dark side?

Advertisment ad adsense adlogger