Page 1 of 1

No Stored Procedures?

Posted: Mon Apr 27, 2009 2:10 pm
by ZLA
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.

Re: No Stored Procedures?

Posted: Mon Apr 27, 2009 2:55 pm
by afm
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.

Re: No Stored Procedures?

Posted: Mon Apr 27, 2009 3:43 pm
by ZLA
Thank you. That is what I was looking for.

Re: No Stored Procedures?

Posted: Tue Apr 28, 2009 10:10 am
by mazhar
Also have a look at following thread. It will give an insight about Able data access pattern.
viewtopic.php?f=47&t=9530

Re: No Stored Procedures?

Posted: Tue Apr 28, 2009 10:48 am
by ZLA
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?

Re: No Stored Procedures?

Posted: Tue Apr 28, 2009 11:11 am
by mazhar
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.