azure-functions-sql-extension/test-outofproc/ReservedTableNameTrigger.cs

// Copyright (c) Microsoft Corporation. All rights reserved.
// Licensed under the MIT License. See License.txt in the project root for license information.

using System.Collections.Generic;
using Microsoft.Extensions.Logging;
using Microsoft.Azure.Functions.Worker;
using Microsoft.Azure.Functions.Worker.Extensions.Sql;

namespace DotnetIsolatedTests
{
    public static class ReservedTableNameTrigger
    {
        /// <summary>
        /// Used in verification of the trigger function execution on table with reserved keys as name.
        /// </summary>
        [Function(nameof(ReservedTableNameTrigger))]
        public static void Run(
            [SqlTrigger("[dbo].[User]", "SqlConnectionString")]
            IReadOnlyList<SqlChange<User>> changes,
            FunctionContext context)
        {
            ILogger logger = context.GetLogger("ReservedTableNameTrigger");
            logger.LogInformation("SQL Changes: " + Utils.JsonSerializeObject(changes));
        }
    }

    public class User
    {
        public string UserName { get; set; }
        public int UserId { get; set; }
        public string FullName { get; set; }

        public override bool Equals(object obj)
        {
            if (obj is User)
            {
                var that = obj as User;
                return this.UserId == that.UserId && this.UserName == that.UserName && this.FullName == that.FullName;
            }

            return false;
        }
    }
}