SqlHelper Class

SqlHelper.cs

public static class SqlHelper
{
    #region Methods

    #region - Public Methods

    /// <summary>
    /// Replace * In SQL Statement With Object Properties
    /// </summary>
    /// <typeparam name="T"></typeparam>
    /// <param name="sql"></param>
    /// <param name="tableAbbreviation"></param>
    /// <returns></returns>
    public static string ReplaceStar<T>(string sql, string tableAbbreviation = null) where T : Axemasta.MusicLibrary.App.Models.Artist
    {
        List<string> propertyNames = new List<string>();

        Type type = typeof(T);

        PropertyInfo[] properties = type.GetProperties();

        string wrapper = string.Empty;

        if (tableAbbreviation != null)
        {
            wrapper = tableAbbreviation + ".";
        }

        foreach (var property in properties)
        {
            propertyNames.Add(wrapper + "[" + property.Name + "]");
        }

        string fields = string.Join(", ", propertyNames);

        return sql.Replace("*", fields);
    }

    /// <summary>
    /// Replace * In SQL Statement With Given Fields
    /// </summary>
    /// <param name="sql"></param>
    /// <param name="tableAbbreviation"></param>
    /// <param name="properties"></param>
    /// <returns></returns>
    public static string ReplaceStar(string sql, string tableAbbreviation = null, params string[] properties)
    {
        List<string> propertyNames = new List<string>();

        string wrapper = string.Empty;

        if (tableAbbreviation != null)
        {
            wrapper = tableAbbreviation + ".";
        }

        foreach (var property in properties)
        {
            propertyNames.Add(wrapper + "[" + property + "]");
        }

        string fields = string.Join(", ", propertyNames);

        return sql.Replace("*", fields);
    }

    #endregion - Public Methods

    #region - Helper Methods

    #endregion - Helper Methods

    #endregion Methods
}