No Stored Procedures?

For general questions and discussions specific to the AbleCommerce 7.0 Asp.Net product.
Post Reply
ZLA
Commodore (COMO)
Commodore (COMO)
Posts: 496
Joined: Fri Mar 13, 2009 2:55 pm

No Stored Procedures?

Post by ZLA » Mon Apr 27, 2009 2:10 pm

I'm just starting to look under the covers for AC7 and I was surprised to find no stored procedures in the database.

Is all data access done via ADO.NET directly to the underlying tables?

Can someone give me a push in the right direction to understand this better?

Thanks.

afm
Captain (CAPT)
Captain (CAPT)
Posts: 339
Joined: Thu Nov 03, 2005 11:52 pm
Location: Portland, OR
Contact:

Re: No Stored Procedures?

Post by afm » Mon Apr 27, 2009 2:55 pm

The AbleCommerce Wiki (http://wiki.ablecommerce.com) has a lot of information that may help. In particular, http://wiki.ablecommerce.com/index.php/ ... cess_Layer.
Andy Miller
Structured Solutions

Shipper 3 - High Velocity Shipment Processing

ZLA
Commodore (COMO)
Commodore (COMO)
Posts: 496
Joined: Fri Mar 13, 2009 2:55 pm

Re: No Stored Procedures?

Post by ZLA » Mon Apr 27, 2009 3:43 pm

Thank you. That is what I was looking for.

User avatar
mazhar
Master Yoda
Master Yoda
Posts: 5084
Joined: Wed Jul 09, 2008 8:21 am
Contact:

Re: No Stored Procedures?

Post by mazhar » Tue Apr 28, 2009 10:10 am

Also have a look at following thread. It will give an insight about Able data access pattern.
viewtopic.php?f=47&t=9530

ZLA
Commodore (COMO)
Commodore (COMO)
Posts: 496
Joined: Fri Mar 13, 2009 2:55 pm

Re: No Stored Procedures?

Post by ZLA » Tue Apr 28, 2009 10:48 am

Thank you Mazhar. That post says "You can download the mygeneration_1309_20081006.exe from following link
http://sourceforge.net/project/showfile ... _id=249524. You need .NET 3.5 in order to run MyGeneration."

I only have VS 2005 running .NET 2.0. Do I just need to download .NET 3.5 or is VS 2008 required?

User avatar
mazhar
Master Yoda
Master Yoda
Posts: 5084
Joined: Wed Jul 09, 2008 8:21 am
Contact:

Re: No Stored Procedures?

Post by mazhar » Tue Apr 28, 2009 11:11 am

You just need .NET 3.5. Infact that is required for MyGen to run. The outputted code doesn't require VS2008 and will work with VS2005 .NET 2.0.

Post Reply