/// <summary>
        /// Find the Id property of the entity type looking for properties with name Id or (entity type name)Id
        /// </summary>
        /// <returns>Id property name or null if none could befound</returns>
        protected static string FindIdProperty()
        {
            var idProperty = EntityColumns
                             .FirstOrDefault(c => c.ToLower() == $"{EntityTypeName.ToLower()}id");

            if (idProperty == null)
            {
                idProperty = EntityColumns
                             .FirstOrDefault(c => c.ToLower() == "id");
            }

            return(idProperty);
        }