>I am new to MM, and wanted to say what a great product this is! Now that I have buttered some people up < g >, I have a question about event objects.
>
>I have to import some data from a text file into a SQL Server database, and am wondering if an event object is the best way to do this. I have three entities (tables):
>
>1. Company
>2. CompanyImport
>3. CompanyUpdate
>
>The way the process works is that I append records from the text file into the CompanyImport table (entity). For each CompanyInport record, I see if it already exists in the Company table. If it does, I update the information in the Company record, if necessary. If the CompanyImport record does not exist in the Company table, I add it to the Company table. In either case (an update or an add), I record what happend in the CompanyUpdate table (entity).
>
>Since this is really my first OOD, am I correct in using an event obect in MM to handle this?
>
>TIA
I would agree with you in wrapping the whole process in an Event object. Events are used when you need to work with more than one Business Object.
P.S. I sent you a private email about the SQL Server procedures you asked for.
Hope this helps.
-----------------------------------------
Cathi Gero, CPA
Prenia Software & Consulting Services
Microsoft C# / .NET MVP
Mere Mortals for .NET MVP
cgero@prenia.comwww.prenia.comWeblog: blogs.prenia.com/cathi