Question: I have a table with 3 columns in which one is empty.

its like this,

```

c1    c2    c3
1    1000  
1    1001
1    1004
2    1005
2    1007
3    1009 

```

I want to insert values to c3 like

```

c1    c2    c3
1    1000    1 
1    1001    2
1    1004    3
2    1005    1
2    1007    2
3    1009    1

```

Can anybody help?

Answer: 
You could write a bit of Reflection code that scans a folder for add-in assemblies and registers all `IPlugin` implementations with the container.

Something like this ought to work:

```
var assemblies = // read all assemblies from disk
var pluginTypes = from a in assemblies
                  from t in a.GetExportedTypes()
                  where typeof(IPlugin).IsAssignableFrom(t)
                  select t;

foreach (var t in pluginTypes)
    container.RegisterType(typeof(IPlugin), t);

```

(code may not compile)
```
    var assemblies = Directory.GetFiles(AppDomain.CurrentDomain.BaseDirectory, "Worker*.dll").Select(f => Assembly.LoadFile(f)).ToArray<Assembly>();

    (from asm in assemblies
        from t in asm.GetExportedTypes()
        where typeof(ICommonWorker).IsAssignableFrom(t) && t.IsClass
        select t).ForEach(x =>
    {
        unityContainer.RegisterType(typeof(ICommonWorker), x, x.FullName, new ContainerControlledLifetimeManager());
    });

```

If anyone still cares, this is what I did to load DLL's dynamically which implemented a specific interface (ICommonWorker).