C# (CSharp) _365AutomatedTests.Framework MSDatabaseConnector.NonQueryExecutor примеры использования

Пример #1

        public void removeAllConclusionsFromOrder(string orderNumber)
        {
            MSDatabaseConnector msDatabaseConnectorLW = new MSDatabaseConnector(Config.MSDbLW);
            String query = $@"use [LW08v6]
                delete [X_ComplexEndings] where OrderItem_ID in (
                select id from [dbo].[X_ORDER_ITEMS] oi 
                where oi.ORDER_NUM in (select order_num from [dbo].[ORDERS] where x_order_code='" + orderNumber + "'))";

            msDatabaseConnectorLW.NonQueryExecutor(query);
        }