/// <summary> /// /// </summary> /// <param name="code"></param> /// <returns></returns> internal IDbQuery SelectEmployeeWithCode5(string code) { return(this.UseQuery("SelectEmployeeWithCode5", p => p.SelectQuery <DbEmployee>() .WithFields(Tuple("Fields_SelectEmployee")) .Where(q => DbFluent.Exists( q.UseSubQuery( DbFluent.SelectQuery(DbFluent.Table("Employee", "Mdm")) .AddIdField(q => DbFluent.FieldAsParameter(nameof(DbEmployee.Code), q.UseParameter("code", DataValueTypes.Text)))))) ) .WithParameters( ElementFactory.CreateScalar("code", code))); }