Exemplos de IBaseClient.ExecuteTextCommand em C# (CSharp)

Exemplo n.º 1

        private void CreateSPTablePrimaryKey_GetList(string storedProcedure)
        {
            var sb = new StringBuilder();

            sb.AppendLine($"CREATE PROCEDURE [dbo].[{storedProcedure}]");
            sb.AppendLine("AS BEGIN");
            sb.AppendLine("  SET NOCOUNT ON;");
            sb.AppendLine("  SELECT 1 as PrimaryKeyId, *");
            sb.AppendLine("  FROM INFORMATION_SCHEMA.TABLE_CONSTRAINTS");
            sb.AppendLine("  WHERE constraint_type = 'PRIMARY KEY'");
            sb.AppendLine("END");

            _client.ExecuteTextCommand(sb.ToString());
        }