Yes this is what I have heard as well. I have used XML schema and xsd many times to construct a "struct" of data out of a database. I agree it is the proper way to implement this.
Reggie > -----Original Message----- > From: [EMAIL PROTECTED] [mailto:mono-list- > [EMAIL PROTECTED]] On Behalf Of Adam Treat > Sent: Monday, January 27, 2003 7:54 AM > To: Daniel Morgan; Piers Haken; Mono-List > Subject: RE: [Mono-list] Automatic Binding of Variables to Parameters in > ADO.NET > > I imagine this is an ideal problem for Microsoft's new XML language/tool. > AFAIK, rumor has it the > new XML language was created to simplify the mapping between SQL database > applications and > strongly typed XML representations. > > --- Daniel Morgan <[EMAIL PROTECTED]> wrote: > > RE: [Mono-list] Automatic Binding of Variables to Parameters in > ADO.NETMaybe > > that's what we need then - for someone to start working on the xsd.exe > tool > > for creating type-safe DataSets. > > > > What would be involved in creating this tool? > > > > Any takers? > > > > -----Original Message----- > > From: Piers Haken [mailto:[EMAIL PROTECTED]] > > Sent: Monday, January 27, 2003 8:46 AM > > To: Daniel Morgan; Mono-List > > Subject: RE: [Mono-list] Automatic Binding of Variables to Parameters in > > ADO.NET > > > > > > Microsoft ships a tool called xsd.exe that generates type-safe > DataSets > > that do basically this. You give it an XML Schma for your table and it > > generates a source file for a class that drives from DataSet but which > has > > typesafe accessors and events. It might be a little heavy-handed for > what > > you want, though. > > > > Piers. > > > > > -----Original Message----- > > > From: Daniel Morgan [mailto:[EMAIL PROTECTED]] > > > Sent: Monday, January 27, 2003 4:52 AM > > > To: Mono-List > > > Subject: [Mono-list] Automatic Binding of Variables to > > > Parameters in ADO.NET > > > > > > > > > Hello, > > > > > > How could I automatically bind variables as paramters in SQL, > > > execute the SQL, and get the results automatically. Would > > > this involve creating new attributes to handle this. I know > > > Glade# uses attributes to bind variables. > > > > > > Let's say we have a database table SOMETABLE with the following > data: > > > > > > ANUM AMONEYVALUE ADATETIME ABOOLEAN AVALUE > > > ==== =========== =================== ======== ====== > > > 5 152.32 2002-12-31 12:34:56 False 9 > > > 6 36.45 2001-01-23 05:12:23 True 8 > > > > > > Here is a struct that will contain the returned values. > > > > > > public struct MyStruct > > > { > > > int someNumber; > > > double someMonetaryValue; > > > DateTime someDataTime; > > > bool someBoolean; > > > } > > > > > > Here is the sample code that demonstrates what I am asking. > > > > > > [SomeMagicMethodParameterDataBind("someValue"] > > > public MyStruct GetData (IDbConnection dbcon, int someValue) > > > { > > > [SomeMagicDataBind("mystruct"] > > > MyStruct mystruct; > > > > > > string sql = > > > "SELECT aNum, aMoneyValue, " + > > > " aDateTime, aBoolean " + > > > "FROM sometable " + > > > "WHERE :someValue " + > > > "INTO mystruct.someNumber, mystruct.someMonetaryValue, " + > > > " mystruct.someDateTime, mystruct.someBoolean"; > > > > > > SomeMagicalClass magic = new SomeMagicalClass(dbcon, sql); > > > magic.ExecuteSQL(); > > > > > > return mystruct; > > > } > > > > > > If I call GetData() with someValue set to 9, I should get a > > > MyStruct struct that has the following resuls: > > > > > > MyStrcut mystruct = GetData(dbcon, 9); > > > > > > // expected results > > > mystruct.someNumber = 5 > > > mystruct.someMonetaryValue = 152.32 > > > mystruct.someDateTime = "2002-12-31 12:34:56" > > > mystruct.someBoolean = false > > > > > > This is what I am interested in having. Now, how do I get > > > this? I'm sure I would need to use reflection heavily and > > > attributes. There would be parsing of SQL for parameters, > > > create parameters based on the parameters in the SQL, update > > > the parameters with information from variables currently in > > > scope that match the name of the parameter, set the value of > > > any input or input/output parameters from the variable that > > > have been bounded earlier, execute the SQL, set the values of > > > any return, output, or input/output variables based on the > > > results in the parameters. > > > > > > Any ideas? > > > > > > If you ever used RAD programming languages like Delphi, > > > Centura/Gupta SQL Windows, PowerBuilder, or Visual Basic, you > > > would understand how powerful this can be for database applications. > > > > > > Thanks Daniel > > > > > > _______________________________________________ > > > Mono-list maillist - [EMAIL PROTECTED] > > > http://lists.ximian.com/mailman/listinfo/mono-list > > > > > > > > > > __________________________________________________ > Do you Yahoo!? > Yahoo! Mail Plus - Powerful. Affordable. Sign up now. > http://mailplus.yahoo.com > _______________________________________________ > Mono-list maillist - [EMAIL PROTECTED] > http://lists.ximian.com/mailman/listinfo/mono-list _______________________________________________ Mono-list maillist - [EMAIL PROTECTED] http://lists.ximian.com/mailman/listinfo/mono-list
