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
Post a Comment