In order to add new threads or reply to existing posts, you have to be logged-in. If you are not registered yet, you need to register first, and then login with your personal credentials.
Fantastic looking product so far, well done! But, and there's always a but ...
What about the rest of us that don't use SQLServer, or those that do but don't want to use stored procedures? Is it possible to use Oracle and no stored procedures in the future? If not, will the source be available so we can modify it ourselves to do this?
Thanks once again, this really does look awesome
We do not support DBs other than MS SQL Server right now, but if you really need to use another DB (that is capable of using stored procedures), you can edit the text templates that generate the database artifacts, such as stored procedures and table structures. You can find the templates in the installation directory of CslaFactory. Once you have created your own Oracle templates, for example, CslaFactory will create scripts for Oracle DBs.
It is even possible to edit the text templates that generate the BusinessObjects. You should be able to tweak them in a manner, that they do not make use of any store procedure at all, but I think this might not be easy.
Anyway, we are impatiently waiting for the ADO.NET Entity Framework. It is very likely that CslaFactory will generate just the mapping tier in the future, allowing the user to use any DB (supported by the Entity Framework) he wants.
Thanks for the swift reply.
I've been playing with the templates and have it using Oracle etc with no problem. The only slight pain is that it seems to automatically add "using System.Data.SqlClient;" so I have to generate and then manually replace with OracleClient which is no biggy really.
Mark,
thanks for the hint. I will add some extra templates containing the using-statements, so you will be able to edit them as well.
Marcel
Your a good man Marcel, and hopefully a millionare by the end of the year ;-)
there is a simple workaround for your problem: In the templates directory, you can find a file named BOLibrary.tt. As it was meant as a hook for customizations, this file is included in all main templates.
If you need to add a your own using statements, simply add them to this file.