newbie

[Erick]

Hi there,

Ok i've downloaded MyGenerations but now what?
How do i get started ?
Is there someplace where i can find out HOW to use this product ?

I'd like to start off by pointing it at some SQL tables and getting some stored procedures built automatically.

In addition can code be generated from within Visual Studio ie can I run MyGeneration through a visual studio wizard ?

e.g. I start new VS project.
I get prompted for database name and location.
I select my tables and press go
VS wizard runs MyGeneration predefined templates (somehow)
and i get my skeleton app built.

All help appreciated.

Erick

[juststeve]

Really? No replies? Is there some place else we newbs are supposed to be getting basic info?

[ormico]

I guess it depends on which database. There are some scripts written already for several databases.

If you are looking for something for SQL Server 2005 or if you just want an example take a look at the post I just wrote \"Article Featuring MyGeneration\"

there are 2 parts of a multi-part article written so far. Part 2 actually talks about how the script works more so than part 1.

It goes through a script that generates stored procedures for SQL Server 2005. Just download the current scripts from CodePlex and drop them into a folder under your MyGeneration Templates folder.

otherwise Run MyGeneration and look at the Template browser and see if there is a script that looks interesting. You can run it and see what it produces or look a the code and see how it works.

[juststeve]

...look at the post I just wrote "Article Featuring MyGeneration"

Thx....where would I find the article?

As a newb I can step into the site here and see plenty of work has gone into a powerful system. But there's nothing (that I've been able to navigate) that says 'Getting Started'.

I've browsed the templates and can run the script from MSQL named: SQL_StoredProcs.vbgen. It runs without error and clearly is finding the tables I told it to act on but the sql it generates is not complete. For example, the Update proc below had all the fields typed correctly but there's nothing following the WHERE statement.

As a newb I don't know if i'm expected to fill that in myself? Or is the fact that I'm hitting a SQL05 server coming into play?

CREATE PROCEDURE [dbo].[affiliateUpdate]
(
...[myFields]
)
AS
SET NOCOUNT ON

UPDATE [affiliate]
SET
...[myFields]
WHERE


RETURN @@Error
GO

[ormico]

Each script is different, but that particular script was supposed to create all of the TSQL for you for CRUD (create read update delete) procedures. There may be something about your table that is confusing it.

My article is here

Part 1
http://blog.zacksfiasco.com/2007/12/build-complete-stored-procedure-based.html

Part 2
http://blog.zacksfiasco.com/2008/01/build-complete-stored-procedure-based.html

More parts coming later.

There is a link fromt the article to the templates. I put mine on codeplex.

Try those and see if you get a better result.

It does have one shortcoming in that it cannot correctly deal with tables that have no keys defined.

[juststeve]

There may be something about your table that is confusing it.

Opps...the confusing link in the chain would appear to be me. I overlooked the 'Target 2005' checkbox.

thankx for the links!