Exceptions are special in that when one is thrown, the .NET runtime will go up the function call-stack until it finds a catch block that can handle the exception. What this means is that you can put a try-catch at the "root" function (the one that calls all the other functions) and any exceptions thrown by any lower functions will be caught in the root function's catch block. Here's an example:

Sub Main()
Try
DoStuff1()
Catch ex As Exception
' Handle exception
End Try
End Sub

Private Sub DoStuff1()
DoStuff2()
End Sub

Private Sub DoStuff2()
DoStuff3()
End Sub

Private Sub DoStuff3()
' Generate an exception
End Sub

If DoStuff3 generates an exception, .NET will jump to the catch block in Main. This way you can assume that all the values returned from your functions will be correct since if there was an error in the function, .NET would jump to the outer catch block, skipping any code that used the return value.

I believe the problem you are trying to solve is how to perform the Object relational mapping. This is a common enough problem that there are packages like NHibernate (Quick start guide) that automate the task for you.

ParagGupta wrote:

I and using SOAP for serialization

You could also switch to binary serialization which doesn't have this limitation.... In my experience, SOAP serialization is not very practical. Once you start serializing a realistic number of objects, the size of the output grows very rapidly. You can also tell that Microsoft is moving away from it since it doesn't support generics.

Hi Steven, I'm assuming that the Plugins folder is a subdirectory of the executable's folder. In that case, you should be able to use the Probing element in the app.config file to have the runtime look for assemblies in that folder. Also, you can read up on the whole process: How the Runtime Locates Assemblies Hope that helps, Eugene

I did some more research and now I have two conflicting views. The documentation on this site says that any source code submitted is free to be used by others in their applications. So what happens if the submitted code is under a GPL license that does not permit this? Which one takes precedence?

Hi, I am thinking about posting an article and some code on code project and have some questions about licensing: -Is there an implicit license placed on code posted or am I free to choose any license? -I am thinking about using the LGPL since my code is a library. Do you guys see any problems with this or have any suggestions for other licenses I should think about? Thanks.