Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 CodeSmith!

Author  Topic 

setbasedisthetruepath
Used SQL Salesman

992 Posts

Posted - 2004-01-09 : 13:51:42
For those of you who haven't heard of it, CodeSmith is a new code generation tool that uses templates to automate some of the repetitive development in software projects. It uses syntax that's quite similar to ASP.NET. Take a look at [url]www.ericjsmith.net/codesmith[/url].

I've put together a small suite of templates that might ease folks into the learning curve and provide a good base for future development, available at [url]www.jbdv.com[/url].

Jonathan

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2004-01-09 : 14:04:27
Hey! You're back. Been busy?

Damian has posted some information about CodeSmith as well. I think it was in one of his blogs:

http://weblogs.sqlteam.com/damianm/

Tara
Go to Top of Page

X002548
Not Just a Number

15586 Posts

Posted - 2004-01-09 : 15:09:04
Yeah, but it requires that you install the .net libraries...


can you do that if you're not an admin on your own client machine?

And where do you get'em...are they free??



Brett

8-)
Go to Top of Page

setbasedisthetruepath
Used SQL Salesman

992 Posts

Posted - 2004-01-09 : 15:12:28
Hey Brett-
CodeSmith is a .NET product, yes. So you will need to install the .NET Framework v1.1 redistributable, which is absolutely free.

Then, take a look at the sample templates the product provides to learn how the product works. At that point you should have sufficient appreciation for both the power of the product and the potential complexity of template design. My work gives you a great starting point with 3 templates out of the box for what is no more than an hour of your paid time. Check it out ...
Go to Top of Page

MichaelP
Jedi Yak

2489 Posts

Posted - 2004-01-09 : 15:44:42
You can make these "templates" generate any sort of repetitive code? Like Data Access code or something??

Michael

<Yoda>Use the Search page you must. Find the answer you will.</Yoda>
Go to Top of Page

setbasedisthetruepath
Used SQL Salesman

992 Posts

Posted - 2004-01-09 : 15:56:42
"Repetitive" isn't really the best descriptor, I shouldn't use it.

Most developers, whether consciously or not, utilize design patterns in their work. The idea behind a codesmith template, loosely, is that one may be able to express that pattern in template logic. The "template" is really .NET code, so it's more more than a simple insertion of text at fixed places, i.e. it's not a mail merge. You're writing code that directs the generation engine to output code, so anything at all can be accomplished. By finding a way to express your pattern in a template, or alternatively by buying a template suite that expresses a pattern that works well, you can save time.

Jonathan
codesmith templates
Go to Top of Page

Merkin
Funky Drop Bear Fearing SQL Dude!

4970 Posts

Posted - 2004-01-09 : 19:45:41
YES!

As Tara mentioned, I'm a big fan.
Basically, when I create a new table in my database, I can use a codesmith template do create all my INSERT, UPDATE, SELECT etc procs. Takes about 3 seconds. Then I can use a different template to create a C# or VB function call that calls those procs that I can paste into my data layer code.

You can do LOTS of cool stuff with it.


Damian
Go to Top of Page

Sitka
Aged Yak Warrior

571 Posts

Posted - 2004-01-09 : 20:59:37
wHOLLEY sHEEEEEEEight

setbased....

freaking eh! God be willing I'll ramp up on your product soon:

to me; it's about thought process....
going back 18 months or so your influence was huge.
Kept me employed, damnit and I owe 'ya.
Now that I pretend to know 'SO' much I may be less employable: but whatever the case consider the donatation a portion of fees due.
Best of luck in the new year and from what I've seen kicking around
the 3W 'you have allowed the hammer to meet nail with your product'

way to have vision, way to persevere,


It is a rich creamy color with a high fat content of 5-7 percent. Being so high in fat, it is usually processed into butter, cheese, or yogurt. An average cow will produce 110 kg. Milk in a lactation period of an average of 149 days
Go to Top of Page

mohdowais
Sheikh of Yak Knowledge

1456 Posts

Posted - 2004-01-10 : 03:42:58
Thanks Jonathan! I've had Codesmith installed on my pc for quite some time now, just waiting to be used. Even Damian's promotion didn't get me to use it yet, but ready templates? Now that should get me cracking at it!!

OS
Go to Top of Page
   

- Advertisement -