----------------------------------------------------------- New Message on BDOTNET
----------------------------------------------------------- From: CSharpMadhu Message 1 in Discussion Hi Group, I was checking out the xsd.exe tool. First I run a SQL Query with FOR XML AUTO, I save this as a file with .xdr extension. Then I run xsd.exe and generate a c# class that matches the xsd schema. C:\>xsd /c /l:cs orders.xsd Microsoft (R) Xml Schemas/DataTypes support utility [Microsoft (R) .NET Framework, Version 1.1.4322.573] Copyright (C) Microsoft Corporation 1998-2002. All rights reserved. Writing file 'C:\orders.cs'. This would account for generating a business object straight from an sql query/database! Now, I was just wondering if the reverse was possible ? i.e., assuming I already have a Business Object (or I would generate one as shown above), can I pass this business object to a stored procedure, which would do an update/insert on the appropriate tables based on the business object. Also can we directly pass a business object/s to a stored proc ? or should it be transformed into some other form before such a thing can be done ? I am looking for a solution in which the stored proc can accept a business object or an array of business objects and commit changes in the appropriate tables. Any help or pointers would be of great help. Madhu ----------------------------------------------------------- To stop getting this e-mail, or change how often it arrives, go to your E-mail Settings. http://groups.msn.com/BDotNet/_emailsettings.msnw Need help? If you've forgotten your password, please go to Passport Member Services. http://groups.msn.com/_passportredir.msnw?ppmprop=help For other questions or feedback, go to our Contact Us page. http://groups.msn.com/contact If you do not want to receive future e-mail from this MSN group, or if you received this message by mistake, please click the "Remove" link below. On the pre-addressed e-mail message that opens, simply click "Send". Your e-mail address will be deleted from this group's mailing list. mailto:[EMAIL PROTECTED]
