Multiple Active Impact Set (MARS) is actually yet another function put-out with ADO.Online 2.0 that allows you to definitely play numerous questions or stored strategies on one commitment. As a result, several submit-merely, read-merely results kits. From inside the previous versions regarding ADO.Websites, you could potentially carry out only 1 inquire each time having fun with an individual partnership. Now, on introduction of SQL Machine 2005 and you may ADO.Websites 2.0, your very easily can execute multiple logical batches in a single partnership. This information demonstrates how to utilize MARS during the an ASP.Internet Webpage. it covers the things in which MARS is suitable and also have results gurus.
Introducing MARS
If you are using DataReader on your software, your currently have seen the dreadful error content: “There is already an unbarred DataReader associated with the so it Connection and that need to be signed first.” MARS enables you to end it content by permitting that open multiple SqlDataReader items on a single union. MARS allows a software to possess more than one SqlDataReader discover towards a link whenever for every example of SqlDataReader try come from yet another order. For every SqlCommand target you add adds a supplementary example into union. (more…)