C# (CSharp) SQL_Generator Col.Values_SQL_Syntax 예제들

예제 #1

 public static string Select(string table, List <string> Columes)
 {
     return($"select {Col.Values_SQL_Syntax(Columes, ",")} from {table};");
 }

예제 #2

        public static string Update(string table, List <Col> Updated_Values, Condition Condition)
        {
            string values = Col.Values_SQL_Syntax(Updated_Values, ",");

            return($"update {table} set {values.Trim(',')} where {Condition.SQL_Syntax()};");
        }

예제 #3

 public static string Select(string table, List <string> Columns, List <Condition> Conditions, string ConditionType)
 {
     return($"select {Col.Values_SQL_Syntax(Columns, ",")} from {table} where {Condition.SQL_Syntax(Conditions, ConditionType)};");
 }

예제 #4

        public static string Update(string table, List <Col> Updated_Values, List <Condition> Conditions, string ConditionType)
        {
            string values = Col.Values_SQL_Syntax(Updated_Values, ","), selector = Condition.SQL_Syntax(Conditions, ConditionType);

            return($"update {table} set {values} where {selector};");
        }