SqlServerGeneration.cs

public class SqlServerQueryGeneration : ISqlQueryGeneration
    {
        public string GetInsertQuery(IEnumerable<string> columns, string table, bool returnId = false)
        {
            if (!columns.Any())
            {
                throw new ArgumentNullException("Columns are required");
            }
            if (string.IsNullOrWhiteSpace(table))
            {
                throw new ArgumentNullException("Table is required");
            }
            string scopeIdentity = string.Empty;
            if (returnId)
                scopeIdentity = " SELECT SCOPE_IDENTITY()";
            return string.Format("INSERT INTO [{0}] ({1}) VALUES({2}){3}", table, string.Join(",", columns), string.Join(",", columns.Select(c => string.Format("@{0}", c))), scopeIdentity).ToUpper();
        }
        public string GetSelectQuery(IEnumerable<string> columns, string table)
        {
            if (!columns.Any())
            {
                throw new ArgumentNullException("Columns are required");
            }
            if (string.IsNullOrWhiteSpace(table))
            {
                throw new ArgumentNullException("Table is required");
            }
            return string.Format("SELECT {0} FROM [{1}]", string.Join(",", columns),table).ToUpper();
        }
    }