asp.net - There is already an open DataReader associated with this Connection which must be closed first. c# -


i'm getting error on controller

system.data.entitycommandexecutionexception: error occurred while executing command definition. see inner exception details. ---> mysql.data.mysqlclient.mysqlexception: there open datareader associated connection must closed first.    @ mysql.data.mysqlclient.mysqlcommand.checkstate()    @ mysql.data.mysqlclient.mysqlcommand.executereader(commandbehavior behavior)    @ mysql.data.entity.efmysqlcommand.executedbdatareader(commandbehavior behavior)    @ system.data.common.dbcommand.executereader(commandbehavior behavior)    @ system.data.entityclient.entitycommanddefinition.executestorecommands(entitycommand entitycommand, commandbehavior behavior)    --- end of inner exception stack trace ---    @ system.data.entityclient.entitycommanddefinition.executestorecommands(entitycommand entitycommand, commandbehavior behavior)    @ system.data.objects.internal.objectqueryexecutionplan.execute[tresulttype](objectcontext context, objectparametercollection parametervalues)    @ system.data.objects.objectquery`1.getresults(nullable`1 formergeoption)    @ system.data.objects.objectquery`1.execute(mergeoption mergeoption)    @ system.data.objects.dataclasses.entityreference`1.load(mergeoption mergeoption)    @ system.data.objects.dataclasses.relatedend.load()    @ system.data.objects.dataclasses.relatedend.deferredload()    @ system.data.objects.dataclasses.entityreference`1.get_value()    @ timee.fingerprint.get_employee() in c:\users\mynamedesktop\time\timee\amodel.designer.cs:line 2234    @ timee.bundyform.verificationcontrol_oncomplete(object control, featureset featureset, eventhandlerstatus& eventhandlerstatus) in c:\users\myname\desktop\time      \timee\bundyform.cs:line 82    @ dpfp.gui.verification.verificationcontrol.<>c__displayclass2.<relay_oncomplete>b__0() 

controller:

 void verificationcontrol_oncomplete(object control, dpfp.featureset featureset, ref dpfp.gui.eventhandlerstatus eventhandlerstatus)     {         clearinfoboxtimer.stop();          datetime entrytime = datetime.now;          dpfp.verification.verification ver = new dpfp.verification.verification();         dpfp.verification.verification.result res = new dpfp.verification.verification.result();          employee employees = null;         foreach (fingerprint fingerprint in this.db.fingerprints)         {             dpfp.template template = new dpfp.template();             template.deserialize(fingerprint.data);             ver.verify(featureset, template, ref res);              if (res.verified)             {                 employees = fingerprint.employee; //im getting error here                 break;             }         }      } 

based on forums read have add multipleactiveresultsets=true; webconfig. in case not applicable because i'm using mysql doesn't support it. there other way make work? please me out guys, thanks.

model of verification

// summary: //     performs system function of fingerprint verification, one-to-one //     comparison of fingerprint feature set fingerprint template produced //     @ enrollment returns decision of match or non-match. public class verification {     // summary:     //     use value specify default far threshold     public const int probabilitynotset = -1;      // summary:     //     initializes new instance of verification class comparing fingerprint     //     feature set fingerprint template using default value of false     //     accept rate (far)     public verification();     //     // summary:     //     initializes new instance of verification class comparing fingerprint     //     feature set fingerprint template , assigns value of far     //     // parameters:     //   farrequested:     //     value of requested far     public verification(int farrequested);      // summary:     //     returns or assigns requested false accept rate (far)     public int farrequested { get; set; }      // summary:     //     performs fingerprint verification , returns comparison decision based     //     on default far threshold     //     // parameters:     //   featureset:     //     dpfp.featureset object     //     //   template:     //     dpfp.template object     //     // returns:     //     verification result object     public static verification.result verify(featureset featureset, template template);     //     // summary:     //     performs fingerprint verification , returns comparison decision based     //     on specified far threshold     //     // parameters:     //   featureset:     //     dpfp.featureset object     //     //   template:     //     dpfp.template object     //     //   farrequested:     //     false accept probability threshold or probabilitynotset use default     //     threshold     //     // returns:     //     verification result object     public static verification.result verify(featureset featureset, template template, int farrequested);     //     // summary:     //     performs system function of fingerprint verification , specifies     //     comparison decision based on far set farrequested property     //     // parameters:     //   featureset:     //     dpfp.featureset object     //     //   template:     //     dpfp.template object     //     //   result:     //     dpfp.verification.result object     public void verify(featureset featureset, template template, ref verification.result result);      // summary:     //     represents results of fingerprint verification operation.     public class result     {         // summary:         //     default c-tor         public result();          // summary:         //     returns or assigns value of achieved far comparison operation.         public int farachieved { get; set; }         //         // summary:         //     returns or assigns comparison decision, indicates whether comparison         //     of fingerprint feature set , fingerprint template resulted in decision         //     of match or non-match. decision based on value of farrequested         //     property         public bool verified { get; set; }     } } 

does below code ?

foreach (fingerprint fingerprint in this.db.fingerprints) {     using(fingerprint)     {         dpfp.template template = new dpfp.template();         template.deserialize(fingerprint.data);         ver.verify(featureset, template, ref res);          if (res.verified)         {             employees = fingerprint.employee; //im getting error here             break;         }     } } 

Comments