Care to tell us where we're supposed to "install" it to use on other projects?

Do I need to add the one produced from the book to every subsequent project I make?

Also, it doesn't seem to work when it loads. Nothing loads in the dropdownlists even though there are connection strings/database connections in the web config.

Can someone give me a step by step on how to go about using it?

Thanks.

Page 464 tells you where to save the .vsz files. The should be in the c:\Program Files\Microsoft Visual Studio 9.0\VC#\CSharpProjectItems folder.

Ok, I was able to work this out to use on the new project I've started using this format.

A follow up question:

In order to use this type of set up in a production environment, would it be best to start a new all-inclusive project and then use the base tables, adding new tables where needed, or would it be better to replicate the base tables in each individual project?

We have several databases going already with data being added daily... but it appears to me that tables such as the ENTUserAccount, or ENTMenuItem, Role, WorkFlow etc would all be the same, over and over.

So I'm thinking that I should start a "BASE" database, include all the "base" tables and go on from there. That way, each dept can have their own workflows/tables/processes and I only have to do most of the stuff once.

Thoughts?

I understand where you are coming from. I've done this both ways. I've put the security and menu tables into a common database and added a new table called Application. Each application that uses the common database must have a record in the Application table and then a foreign key must be added to the other tables. For example, the menu items need to be associated with an application so they only show up for the application requesting data.
If you work at a place with a lot of developers you'll need to coordinate the maintenance of the common database with the other developers or have one person control that database.
One of the nice features of having a common database is that you only need to add the users once and then you can associate them with a role for a specific application. This makes maintenance of users easier.
A drawback of this approach is that you now have a single point of failure for all the applications that use this database.

I am having a similiar problem where the generator does not show anything in the dialog box. It also does not appear as options in the V2.PaidTimeOffBLL V2.PaidTimeOffDAL, or http://localhost/PaidTimeOffUI/ projects.

Does anyone have any guidance?

I have the same problem as GenXisT , I see the options, can select them but the connection list box does not list anything except for localsqlserver even though there are other connections. What did I miss in the install?

Thanks in advance
Richard

Figured this one out, if you don't have a connection entry in your webconfig you will not get the pick list.

The next problem I ran into was "invalid type" this was due to the fact that a money type was not defined in the generator.

To isolate the problem I added + dr["DataType"].ToString() to the exception code so I could see what the type was.

I added for the SQL (private string GetSQLType(DataRow dr))
case "System.Decimal":
return " money";
and for the C# (private string GetCSharpType(DataRow dr))
case "System.Decimal":
return " decimal";

Hi,

I'm having a very similar issue. I cannot get anything to appear in the drop downs. I have used the connection strings in the web.config to successfully build test pages etc. I'm using VS2008 Stnd, SQL2005 Exp, on Windows 7 Ultimate and IIS7.

I have tried different app pools and logins for SQL but no luck. I have reverted to windows authorisation for simplicity but no luck in getting any connections to appear in the Database Selector. VSZ file in place with blank lines etc all as page 464.

Any further guidance greatly appreciated.

Gilbo

Don't know if I can help but I will try.

You have a solution that contains a website?

Are you using localhost or an remote website? I am at work now, but from what I remember when I was looking a the code I think "localhost" is where it looks for the web.config.

One thing I did while I was tring to figure this out was to add a new text box to the control and disabled the drop down and the code for populating the drop down and used the text box to manually add the connection string. It worked but....


Richard

Hi Richard,

I was just about to post an update and your right, I was using the internal webserver from VS2008 and as soon as I put the UI on IIS as a virtual directory and application it springs into life.

Andrew