Need this ability to generate non-qualified I/U/D commands RRS feed

  • Question

  • Hello,

     we need a provision to generate non-qualified I/U/D commands when using ADO.NET. We want to use these commands generated from our provider instead of using default DbCommandBuilder implementation. Please let me know if there is a way to do it.

     Thanks and regards


    Wednesday, July 25, 2012 3:33 PM

All replies

  • Hi Vish,

    You could achieve this by the properties of SqlDataAdapter. Generate the sql command which you want and assign this command to SqlDataAdapter.<I/U/D>Command property.

    You could refer to the following link for more information:

    Hope this could help you.

    Best Regards,

    Tony Xiao [MSFT]
    MSDN Community Support | Feedback to us

    • Proposed as answer by Tony xiao Monday, July 30, 2012 8:17 AM
    Monday, July 30, 2012 8:17 AM
  • Hi Tony,

    I should have been more clear on my requirement!

    We have our own implementation of CommandBuilder class and when using 'Data Source Configuration Wizard', we want the wizard to use Our CommandBuilder class methods but it seems the wizard always calls the Base class System::Data::Common::DbCommandBuilder methods for GetInsertCommand(), GetUpdateCommand() and GetDeleteCommand() methods(since they are non virtual?). Is there a way to hook up our CommandBuilder implementation for this wizard?

    Thanks for your help.



    • Edited by hsvish Thursday, August 2, 2012 5:49 AM
    Thursday, August 2, 2012 5:48 AM