MultipleConstraints

default

markdown

#Multi Constraints
[[_TOC_]]

##Question

Is there a way to pre-build a string or object and store it at the application level? to let each session copy it and change the connection string.  It is not optimal to have to call the AddConstraint() method so many times every time a user wants to connect to a database

##Answer

Multiple constraints can be stored in application as below.

**a.** Before adding constraints, put this line of code:

***Izenda.AdHoc.Database.Driver driver = AdHocContext.Driver;***

and change all their "AdHocContext.Driver.AddConstraint(...)" lines to "driver.AddConstraint(...)"

**b.** Add following line of code right before adding first custom constraint:

***AdHocContext.Driver.BeginAddingMultipleConstraints();***

**c.** Add following line of code right after adding last custom constraint:

***AdHocContext.Driver.EndAddingMultipleConstraints();***

##Global.asax (C♯)
```csharp

public class CustomAdHocConfig : FileSystemAdHocConfig {
    public static void InitializeReporting() {
      //Check to see if we've already initialized.
      if (HttpContext.Current.Session == null || HttpContext.Current.Session["ReportingInitialized"] != null)
        return;

Izenda.AdHoc.Database.Driver driver = AdHocContext.Driver;    //before adding any constraints, put this line

AdHocContext.Driver.BeginAddingMultipleConstraints();    // add as many constraints as you want between begin and end
    
      driver.AddConstraint("[dbo].[Orders].[CustomerID]", "[dbo].[Invoices].[CustomerID]");
      
      driver.AddConstraint("[dbo].[Orders].[OrderID]", "[dbo].[Invoices].[OrderID]");
      
      AdHocContext.Driver.EndAddingMultipleConstraints();          
      ...
      }
}
```

Uploading file...

Header

Sidebar

![Izenda Logo](http://izenda.com/wp-content/uploads/2014/12/IzendaNewLogoBlueTR.png)

---

* [[Izenda 7 Series Documentation|https://www.izenda.com/docs/]]
* [[Release Notes]]
* [[Upgrade Best Practices|FAQ/Izenda-Update-Best-Practices]]
* [[FAQ]]
* [[Tutorials]]
* [[The Izenda API|/API/AdHocConfig]]
* [[The AdHocSettings class|/API/AdHocSettings]]
* [Developer Links and Guides](/Guides/Developer-Links-and-Guides)
* [[Known Issues]]

---

* <a href="http://www.izenda.com" rel="nofollow" target="_blank">Izenda Website</a>
* [Product Video](https://www.youtube.com/watch?v=X3-yWFq0w5A)
* <a href="http://www.izenda.com/blog" rel="nofollow" target="_blank">Izenda Blog</a>
* <a href="http://www.izenda.com/company/" rel="nofollow" target="_blank">About Us</a>
* <a href="http://www.izenda.com/contact-us/" rel="nofollow" target="_blank">Contact Us</a>

---
* [Guide To Report Design](/Guides/ReportDesign)
* [Making Custom Forms Video](http://www.youtube.com/watch?v=5b2axJlgdFs)

---

* [[Acknowledgements]]

Edit message:

Cancel

Editing MultipleConstraints

Header

Sidebar