Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>No, you can't bind "after" - for one thing, web applications are stateless and you have no control over the order of events, but more importantly, Ninject modules define your IoC container and this configuration happens before almost <em>anything</em> else in the application or request lifecycle.</p> <p>If you're saying that the user would pick this from a drop-down, then the act of choosing the repository is part of your <em>application logic</em>, not part of your IoC configuration. The way to deal with this is to create a factory interface. The implementation can be a thin wrapper around the Ninject kernel itself.</p> <pre><code>public interface IRisksRepositoryFactory() { IRisksRepository GetRepository(string name); // Optional: add a GetRepositoryNames() method for populating dropdowns, etc. } public class NinjectRisksRepositoryFactory { private readonly IKernel kernel; public NinjectRisksRepositoryFactory(IKernel kernel) { if (kernel == null) throw new ArgumentNullException("kernel"); this.kernel = kernel; } public IRisksRepository GetRepository(string name) { return kernel.Get&lt;IRisksRepository&gt;(name); } } </code></pre> <p>For this particular implementation you'd want to make sure you use named bindings (although generally speaking you could also use the metadata system), and do each binding explicitly:</p> <pre><code>Bind&lt;IRisksRepository&gt;() .To&lt;MySqlRisksRepository&gt;() .InRequestScope() .Named("mysql") .WithConstructorArgument("connectionString", GetConnectionString("mydb1")); Bind&lt;IRisksRepository&gt;() .To&lt;OracleRisksRepository&gt;() .InRequestScope() .Named("oracle") .WithConstructorArgument("connectionString", GetConnectionString("ordb1")); Bind&lt;IRisksRepositoryFactory&gt;() .To&lt;NinjectRisksRepositoryFactory&gt;(); </code></pre> <p>It's also possible to do this without creating each binding explicitly, particularly if all targets are the same type (i.e. you only have a <code>MySqlRisksRepository</code>), by passing the connection string or related symbol as a parameter to the <code>Get</code> call and binding to a contextual method instead of a type - but I'd recommend against it, since it's really swimming against the current as far as DI in general goes.</p> <p>One more thing: Don't worry that this resembles the "service locator" anti-pattern, because that's all it is - a superficial resemblance. When objects need to be able to create dependencies on the fly, creating special-purpose factories around the IoC container is the recommended solution, as it minimizes kernel exposure to a single class which could be easily replaced if you switched to a different framework.</p>
    singulars
    1. This table or related slice is empty.
    1. POUsing Ninject dynamically to connection to different databases
      singulars
      1. PTQuestion
    1. PTAnswer
    1. This table or related slice is empty.
    1. USAaronaught
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. POUsing Ninject dynamically to connection to different databases
      singulars
      1. PTQuestion
    1. This table or related slice is empty.
    1. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTAcceptedByOriginator
    2. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    3. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    1. COThanks for the response! I am kind of following what you are saying but still a little fuzzy on how the named bindings are working. Would you have an example site or something just for some background info?
      singulars
      1. PO
      1. USJohn Lee
    2. COSpecifically - I'm not sure where the binding is supposed to happen. Right now its in the Application start, but would this be done in the login? Also, this is support multiple repositories, I just listed one for sake of simplicity.
      singulars
      1. PO
      1. USJohn Lee
    3. CO@jjlee316 the bindings are done at the same time you create the kernel, normally in a `NinjectModule` that you load into the kernel. You can do it in `Global` if you want, although if you're using MVC3 and NuGet, it will install a bootstrapper in `App_Start` which is a little cleaner. Either way, bindings are one of the very first things to happen in an app, certainly long before any actions are executed.
      singulars
      1. PO
      1. USAaronaught
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload