C# (CSharp) ICodeWriterPlSql.If Examples

Example #1

 private void WriteExecImmediatWhenNotExists(string fromSource, string whereCondition, ICodeWriterPlSql sql)
 {
     updater.WriteLine("SELECT count(*) INTO {0} FROM {1} WHERE ROWNUM=1 AND {2};",
                       VarNameFoundCount, fromSource, whereCondition);
     updater.If("{0} <> 1", VarNameFoundCount);
     updater.WriteSetVar(VarNameSql, sql);
     updater.WriteExecImmediatVariable(VarNameSql);
     updater.EndIf();
 }