|
 |
aspdotnet_website_programming thread: Data tier methods automation
Message #1 by "Jacques PHILIP" <jphilip@n...> on Wed, 14 Aug 2002 15:57:20 -0800
|
|
Hello all,
I got tired of writing C# code to just map stored procedures as in the
ThePhile application, so I wrote a little helper program to do this
automatically.
It parses the stored procedure and maps the parameters and SQL data types to
C# parameters and writes the method.
I added it to my external tools in VS and it saves me a lot of time and
avoids making mistakes in the length of the parameters...
If anyone is interested, let me know, I will make it freely available.
Jacques PHILIP
Message #2 by "John Rodriguez" <jr534@c...> on Wed, 14 Aug 2002 17:14:28 -0700
|
|
I would be interested in using this code.
-J
John Rodriguez
Microsoft Summer Intern 2002
Exchange Mail Server Team
-----Original Message-----
From: Jacques PHILIP [mailto:jphilip@n...]
Sent: Wednesday, August 14, 2002 4:57 PM
To: Website Programming with ASP.NET
Subject: [aspdotnet_website_programming] Data tier methods automation
Hello all,
I got tired of writing C# code to just map stored procedures as in the
ThePhile application, so I wrote a little helper program to do this
automatically.
It parses the stored procedure and maps the parameters and SQL data
types to
C# parameters and writes the method.
I added it to my external tools in VS and it saves me a lot of time and
avoids making mistakes in the length of the parameters...
If anyone is interested, let me know, I will make it freely available.
Jacques PHILIP
Message #3 by "Huynh, Trung" <Trung.Huynh@h...> on Wed, 14 Aug 2002 19:35:52 -0500
|
|
Me too.
-----Original Message-----
From: John Rodriguez [mailto:jr534@c...]
Sent: Wednesday, August 14, 2002 7:14 PM
To: Website Programming with ASP.NET
Subject: [aspdotnet_website_programming] RE: Data tier methods
automation
I would be interested in using this code.
-J
John Rodriguez
Microsoft Summer Intern 2002
Exchange Mail Server Team
-----Original Message-----
From: Jacques PHILIP [mailto:jphilip@n...]
Sent: Wednesday, August 14, 2002 4:57 PM
To: Website Programming with ASP.NET
Subject: [aspdotnet_website_programming] Data tier methods automation
Hello all,
I got tired of writing C# code to just map stored procedures as in the
ThePhile application, so I wrote a little helper program to do this
automatically.
It parses the stored procedure and maps the parameters and SQL data
types to
C# parameters and writes the method.
I added it to my external tools in VS and it saves me a lot of time and
avoids making mistakes in the length of the parameters...
If anyone is interested, let me know, I will make it freely available.
Jacques PHILIP
Message #4 by "jiang tang" <jtang63@y...> on Wed, 21 Aug 2002 16:24:06
|
|
Heros see eye to eye.
Actually for any repetitive job, there is an automation to do, including
some ASP pages. I have been doing this for almost every project I was
working on.
The way to do it is that first you write a template, then separate those
configurable or customizable variables (you can set up a small database to
store and configure those variables), then you write a VB program to get
those customizable variables from the database to automate your coding
process.
I call it "adaptive code automation".
|
|
|
View Cart
