Tips and Tricks
A place to store useful info I don't want to lose



Subscribe to "Tips and Tricks" in Radio UserLand.

Click to see the XML version of this web page.

Click here to send an email to the editor of this weblog.
 

 

 

   Olymars.

Some pretty cool stuff here.

We've all had to write the same repetitive code over and over again such as the following in order to connect to a db.

  • Write SQL code and create at least 4 stored procedures per table in the database (Insert, Update, Delete and Select SQL statement)
  • Write SQL code and create custom stored procedures that will reflect the complexity of their database diagram (Example: write a SQL statement that can update several tables in one call, write SQL statement that can bring back data from several tables using inner join statement…)
  • Write ADO.Net code (using VB .NET, C# .NET or whatever language supported by the .NET platform) that is responsible for calling those stored procedures. Developers have to take special care with the parameters type to be declared as long as the parameters direction (input, output…)
  • Write abstract classes that map exactly to their database tables for easy data retrieving
  • Write Windows or/and Web forms that can manage (Add, Update, Delete) their database tables content

Well supposedly the tool Olymars does this all for us.  Very, very interesting.

So far after an intial appraisal it looks very cool.

[Sean 'Early' Campbell & Scott 'Adopter' Swigart's Radio Weblog]


Click here to visit the Radio UserLand website. © Copyright 2003 Eric Hartwell.
Last update: 4/1/2003; 12:23:32 PM.
This theme is based on the SoundWaves (blue) Manila theme.

March 2003
Sun Mon Tue Wed Thu Fri Sat
            1
2 3 4 5 6 7 8
9 10 11 12 13 14 15
16 17 18 19 20 21 22
23 24 25 26 27 28 29
30 31          
Feb   Apr


"Data! data! data!" he cried impatiently. "I can't make bricks without clay."
— Sherlock Holmes to Dr. Watson in "The Adventure of the Copper Beeches" by Arthur Conan Doyle. 


"I like deadlines," cartoonist Scott Adams once said. "I especially like the whooshing sound they make as they fly by."


"There is nothing like that feeling of spending days and days banging your head against a wall trying to solve a programming problem then suddenly finding that one tiny obscure and seemingly unrelated piece of the puzzle that unlocks the solution. Oh yeah!"

- Chris Maunder, CodeProject Newsletter 28 Jan 2002


"Management at eSnipe, which is me, is also feeling the pain of the 2002 bear market. So rather than pout about it, I bought some stuff on eBay that I really didn’t need, but made me feel better."

- Tom Campbell, president of eSnipe