Class Builder Wizard

New Post: CMD Param and SelectList

whatsit — Thu, 10 Jul 2008 03:25:51 GMT

Hi Tom,

I'm unsure why you would only be able to insert. Did you re-generate the code and sql stored procedures or did you just take the parameters out of the Select method? You need to re-generate the code instead of just editing the methods after generation. You should also recreate the stored procedures in the database once they are generated correctly.

While the wizard is running, you should edit the KeyColumns collection for the table so that it only includes the ID column. I believe that will fix your problem once you deploy the newly generated stored procedures to your database.

Thanks.

-Jason

New Post: CMD Param and SelectList

ad5qa — Thu, 10 Jul 2008 02:51:10 GMT

Sweet, thanks for all the help.

I removed all the parameters in the select method except for id...

public

Announcements Select(int id)

I do my stuff with the ID then Save it back using the same ID #18. However, it creates a new item rather then updating. I will build an update statement be hand unless there is something I am missing. Actually to save time I will add then delete the previous if no errors occur.

Thanks.
Tom

Commented Issue: error to install version 3.0.2

whatsit — Mon, 07 Jul 2008 15:28:29 GMT

Error: this template attempted to load an untrusted component 'ClassBuilderWizard, Version=2.2.0.0, Culture=neutral, PublicKeyToken=d66ed855fe72ec20, Custom=null'. For more information on this problem and how to enable this template, please see documentation on Customizing Project Templates.

i installed the latest version 3.0.2 ...i didn't have other version installed.... on visual studio 2005 .... i tried to repair ...remove ...follow the tips from the other issue ...but nothing .... the error is the same

any ideas?

thanks
luca
Comments: ** Comment from web user: whatsit **

Hi luca,

I cannot seem to duplicate this problem. When did you download the 3.0.2 release? Was it recently or a while ago? I had to update the installer for that version and if you had downloaded prior to that date/time, you may have gotten a bad installer.
Please check the date and time on the release section to make sure you have the latest version.

Thanks.
-Jason

Commented Issue: error to install version 3.0.2

lucaclic — Fri, 04 Jul 2008 01:35:19 GMT

hi jason
i get this error only when i try to use the Class Builder Wizard with the web project , i'm using C# ... i tried to use it iwhit the class library project and everything work fine , the Class Builder Wizard is a good project

Thanks

luca

Commented Issue: error to install version 3.0.2

whatsit — Wed, 02 Jul 2008 19:30:42 GMT

Hi luca,
I understand you are using Visual Studio 2005 and are installing the Class Builder Wizard for the first time.
Could you please tell me:
1) What type of project you are running the wizard for (web, windows, class library, etc)
2) What language you are running the wizard for (C# or VB.NET)

Thanks.
-Jason

Created Issue: error to install version 3.0.2

lucaclic — Tue, 01 Jul 2008 13:09:09 GMT

Commented Issue: Error After Install of V3.0

lucaclic — Tue, 01 Jul 2008 05:26:06 GMT

After uninstalling V 2.0 and installing 3.0, ClassBuilder 3.0 will not run. It throws this error
-------------------------------------------------------------------------------------------------------
---------------------------
Microsoft Visual Studio
---------------------------
Error: this template attempted to load an untrusted component 'ClassBuilderWizard, Version=2.2.0.0, Culture=neutral, PublicKeyToken=d66ed855fe72ec20, Custom=null'. For more information on this problem and how to enable this template, please see documentation on Customizing Project Templates.
----------------------------------------------------------------------------------------------------
Looks like the 3.0 does not properly register itself and remnants of V2.0 are stuck in the registry.
Any Ideas?
cheers,
yousaid
Comments: ** Comment from web user: lucaclic **

i have the same problem :

i installed the latest version 3.0.2 .... on visual studio 2005 .... i tried to repair ...remove ...follow your tips ...but nothing .... the error is the same

any ideas?

thanks
luca

NEW POST: CMD Param and SelectList

whatsit — Mon, 09 Jun 2008 02:14:26 GMT

ad5qa wrote:
Very nice, thanks for the example. How about to edit a record?

Would I just modify the parameters? I cant try it out right now but I thought I would ask for the est method. I am sure someone else would like a walkthru also, so this is a great forum for some FAQ.

SqlParameter p = new SqlParameter("@id", "4");
string sql = "UPDATE myTable SET active = 'Y' WHERE ID = @id ";
List<Gallery> myList = dataAccessInstance.SelectList(sql, CommandType.Text, new SqlParameter[] { p });

Hi ad5qa,

Usually, you would update an item with the other methods provided in the data access class. The idea is to use the strongly typed objects to move your records around your application and save them back to the database. The best idea I have for you is something like this:

//get the record from the database
Gallery gal = dataAccessInstance.Select(4); //assume you choose ID as the key for your row
gal.active = "Y";
//save the record back to the database
gal = dataAccessInstance.Save(gal);

All of the work is already done for you in the Select and Save methods. The only time you should need to pass your own SQL statements through the data access class are when you are doing something other than selecting by ID/Key or doing some other non-CRUD operation. I only added the SelectList method so that the data access class could be expanded easily. You might create your own stored procedure that still returns a full set of records, but performs some other logic, too. That is when you would use the SelectList method.

If that's as clear as mud, please reply.

Thanks.
-Jason

NEW POST: CMD Param and SelectList

ad5qa — Mon, 09 Jun 2008 00:41:34 GMT

Very nice, thanks for the example. How about to edit a record?

Would I just modify the parameters? I cant try it out right now but I thought I would ask for the est method. I am sure someone else would like a walkthru also, so this is a great forum for some FAQ.

SqlParameter p = new SqlParameter("@id", "4");
string sql = "UPDATE myTable SET active = 'Y' WHERE ID = @id ";
List<Gallery> myList = dataAccessInstance.SelectList(sql, CommandType.Text, new SqlParameter[] { p });

NEW POST: CMD Param and SelectList

whatsit — Sun, 08 Jun 2008 04:32:35 GMT

ad5qa wrote:
I am not to familiar with command parameters. Can someone give me a tip on using the folowing.

List<Gallery> GaleryDataAccess.SelectList(string sql, System.Data.CommandType commandType, System.Data.SqlClient.SqlParameters[] parameters);

Lets say I want to SELECT * FROM Gallery WHERE Catagory = 'Missionaries'

Thanks for any help

Hi ad5qa,

If you just want to execute your SQL statement as-is, you can call the SelectList method like this:

List<Gallery> myList = dataAccessInstance.SelectList("SELECT * FROM Gallery WHERE Category='Missionaries'", CommandType.Text, new SqlParameter[] { });

Another way to use it would be to create a parameter for the value you want to pass to the query, like this:
SqlParameter p = new SqlParameter("@Category", "Missionaries");
List<Gallery> myList = dataAccessInstance.SelectList("SELECT * FROM Gallery WHERE Category=@Category", CommandType.Text, new SqlParameter[] { p });

I hope that clarifies it for you. If you have any questions, please feel free to reply to this thread.

Thanks.
-Jason

NEW POST: CMD Param and SelectList

ad5qa — Tue, 03 Jun 2008 01:36:31 GMT

I am not to familiar with command parameters. Can someone give me a tip on using the folowing.

List<Gallery> GaleryDataAccess.SelectList(string sql, System.Data.CommandType commandType, System.Data.SqlClient.SqlParameters[] parameters);

Lets say I want to SELECT * FROM Gallery WHERE Catagory = 'Missionaries'

Thanks for any help

Source code checked in

whatsit — Mon, 26 May 2008 21:28:49 GMT

Check-in for version 3

NEW POST: General Comments

whatsit — Thu, 15 May 2008 14:08:52 GMT

yousaid wrote:
...
UNRELATED.

I noticed this line in the generated class file:
--------------------------------------------------------------
VB
Dim newEx As System.Exception = New System.Exception("From Save. See inner exception.", ex)
--------------------------------------------------------------
Specifically, I am refering to " See inner Exception". What exactely is it referencing?
This line only occurs in tables with Foreign Keys. Is there an easy way to use a related table? Eg.
Products Table has Category Id as a foreign key. But I want the category name to be rendered in a dropdown FROM the CATEGORY table.
Any Ideas?
Thanks again and GREAT JOB !
cheers,
yousaid

Hi yousaid,
The newest feature of the Data Access class is that it keeps a list of all of the errors that occured in the instance you are using. This seems to be a good way to let your business logic know about problems on the data layer without tearing down your app domain by throwing an exception.

You will notice that the System.Exception class has a property on it called "InnerException." If you were to read through the list of errors the Data Access class encountered, you would need to look at this property to see what the error actually was. The note about "See inner Exception" is just a way of telling where (what method) the exception was thrown. If that was not there and you performed multiple operations with the Data Access class, you might not know which of your method calls actually failed.

As far as your category problem goes: I would generate an entity and data access class for the category table. You can use the SelectAll method to retrieve the categories and populate your dropdown. Make sure to bind the id / foreign key of the category to the data value of the list.

Thanks.
-Jason

CLOSED ISSUE: Error After Install of V3.0

whatsit — Thu, 15 May 2008 13:57:46 GMT

NEW POST: General Comments

yousaid — Wed, 14 May 2008 21:07:57 GMT

THIS IS a cross Post. I made a mistake and posted it in Issues.
----------------------------------------------------------------------

GREAT JOB, it works now !
The new build fixed the issue on both systems. You can now close this issue. I have one question that is

UNRELATED.

I noticed this line in the generated class file:
--------------------------------------------------------------
VB
Dim newEx As System.Exception = New System.Exception("From Save. See inner exception.", ex)
--------------------------------------------------------------
Specifically, I am refering to " See inner Exception". What exactely is it referencing?
This line only occurs in tables with Foreign Keys. Is there an easy way to use a related table? Eg.
Products Table has Category Id as a foreign key. But I want the category name to be rendered in a dropdown FROM the CATEGORY table.
Any Ideas?
Thanks again and GREAT JOB !
cheers,
yousaid

COMMENTED ISSUE: Error After Install of V3.0

yousaid — Wed, 14 May 2008 18:18:29 GMT

GREAT JOB, it works now !
The new build fixed the issue on both systems. You can now close this issue. I have one question that is

UNRELATED.

I noticed this line in the generated class file:
--------------------------------------------------------------
VB
Dim newEx As System.Exception = New System.Exception("From Save. See inner exception.", ex)
--------------------------------------------------------------
Specifically, I am refering to " See inner Exception". What exactely is it referencing?
This line only occurs in tables with Foreign Keys. Is there an easy way to use a related table? Eg.
Products Table has Category Id as a foreign key. But I want the category name to be rendered in a dropdown FROM the CATEGORY table.
Any Ideas?
Thanks again and GREAT JOB !
cheers,
yousaid

UPDATED RELEASE: Class Builder Wizard 3.0.2 (May 12, 2008)

Wed, 14 May 2008 13:51:01 GMT

As always, uninstall the previous version and install this latest version. Hopefully we can stop building and re-building today and we finally have a stable release for 3.x. Thanks to all that helped test this new version.

Updated installer to install proper web templates for version 3.0.2. If you downloaded and installed prior to 05/13/2008 5:40pm U.S. Central Time, please download again.

NEW POST: General Comments

whatsit — Tue, 13 May 2008 22:38:18 GMT

Hi yousaid,

I just updated the installer for 3.0.2 with a fix that will hopefully fix your issue. The version of the program is still 3.0.2 (no code changes); just a configuration change on the installer. So, please re-download the 3.0.2 installer, uninstall all previous versions, and install the downloaded 3.0.2 package.
As always, please let me know your results.

Thanks.
-Jason

UPDATED RELEASE: Class Builder Wizard 3.0.2 (May 12, 2008)

Tue, 13 May 2008 22:37:30 GMT

As always, uninstall the previous version and install this latest version. Hopefully we can stop building and re-building today and we finally have a stable release for 3.x. Thanks to all that helped test this new version.

05/13/2008 - Updated installer to install proper web templates for version 3.0.2. If you downloaded and installed prior to 05/13/2008 5:40pm U.S. Central Time, please download again.

NEW POST: General Comments

yousaid — Tue, 13 May 2008 21:04:50 GMT

I still have the same problem. Infact, I am getting same behavior on two different machines.

Machine #1: Laptop, XP SP1, VS 2008 Pro and VS Web Developer installed. VS Extensions is also installed including Dynamic Data preview, etc.

Machine #2: Is a Desktop with same applications installed.

Here is what I have done:

(1) Uninstalled existing 2.2. xxx versions.
(2) Installed 3.1 xxx.
Then tried to use the wizard from an app., I get the error I posted.

Then I reinstalled v2.2.xx and THEN installed 3.1.xxx WITHOUT unistalling 2.2.xxx version.

Then tried to use the wizard from an app, The error is NOT thrown, BUT the WIZARD loads a blank window and does not pick up the DB, just blank.

Behavior is consistent on both machines. I have even uninstalled it from GAC, but still not working.
Here is the link to error
http://www.codeplex.com/ClassBuilderWizard/WorkItem/View.aspx?WorkItemId=4683

Just wondering....... Do I need to Delete every app built with v2.2 in the GAC?
Any ideas?
Thanks
yousaid