https://www.codetrigger.com/forum/recent.aspx CodeTrigger - Recent Posts en-us http://blogs.law.harvard.edu/tech/rss Jitbit AspNetForum Mon, 04 Dec 2017 15:17:42 GMT Mon, 04 Dec 2017 15:17:42 GMT https://www.codetrigger.com/forum/topic31-incremental-development-of-codebase.aspx Hi,
Updating a project is transparent, once you are aware how its supposed to work, each time you want to generate code you only select the NEW/UPDATED entities you want to (RE)generate. That's why it reverts all to unchecked at the start of each session. It doesn't try to remember what you have already generated because it doesn't need to. If you select an entity then its code will be (re)generated. If you don't select it then its code will not be (re) generated.

There are some base classes that are regenerated every time. If you make changes to them or don't want them regenerated, add them to the 'escaped files' list, otherwise you can ignore them and let them get regenerated. In general avoid changing the generated code directly, however if you do, add the file to the 'escaped files list to avoid it being overwritten.
It is not possible to customise the code generation template (ie prior to code generation). There are other template based code generators out there that fulfil that requirement.

For information on how you can customise the CodeTrigger generated code (ie after code generation) see the 'Customization' section of the features page.
edited by migrator on 12/4/2017]]> Mon, 04 Dec 2017 15:17:42 GMT https://www.codetrigger.com/forum/topic31-incremental-development-of-codebase.aspx Hi, Let us say I generate a multi-tier application from database. Over a period of time if I add additional database objects, does the tool support adding new code to existing project? Do I have to re-generate the entire application again? What about customization that are done, will it get overwritten? Also, is it possible to generate a ASP.NET Web API 2.x code base from the database? Is it possible to customize the code generation template? I look forward to your response]]> Mon, 04 Dec 2017 15:16:33 GMT https://www.codetrigger.com/forum/topic30-change-db-connection-string-at-runtimedynamically.aspx Hi, there are some public properties that were created specifically for this purpose, i.e. changing the connectionstring at runtime.
Usage:
At an appropriate place in the code, you can override the connection string by setting it statically:

DATACONN0_TxConnectionProvider.ConnectionString = "Server=xxx;Port=xx;Initial Catalog=etc etc";
DATACONN0_BaseData.StaticConnectionString = "Server=xxx;Port=xx;Initial Catalog=etc etc";

both overrides would be necessary, one is just for queries (non-transactional) and the other provides transactional support.]]> Mon, 04 Dec 2017 15:15:16 GMT https://www.codetrigger.com/forum/topic30-change-db-connection-string-at-runtimedynamically.aspx What is the best way to set the connection string at run time, so the generated data and business objects point to a database specified by code. I need to use this in application where I can't specify the database in a app.config file, since it won't be accessible at runtime]]> Mon, 04 Dec 2017 15:13:07 GMT https://www.codetrigger.com/forum/topic29-integrate-it-with-entity-framework.aspx Hi,
There is no plan to incorporate Entity Framework.
CodeTrigger is an alternative to Entity Framework, to remove the dependency on such 3rd party libraries in your finished product, by using the 100% just code approach. Hence it wouldnt make any sense to bundle Entity Framework.]]> Mon, 04 Dec 2017 15:11:40 GMT https://www.codetrigger.com/forum/topic29-integrate-it-with-entity-framework.aspx Hi , do you have plans to incorporate Entity Framework into your code generator]]> Mon, 04 Dec 2017 15:11:23 GMT https://www.codetrigger.com/forum/topic28-dont-want-the-security-tables-in-mvc-menu.aspx Thank you, you have been very helpful and I'm really liking this generator.]]> Mon, 04 Dec 2017 15:02:38 GMT https://www.codetrigger.com/forum/topic28-dont-want-the-security-tables-in-mvc-menu.aspx Hi,Thanks for letting me know it resolved the issue.The items on the menu are defined in the menuitems.xml file in the root of the mvc project. If you edit that file and remove the links to the security tables, the menu items will not show up at runtime.In addition, once the security tables have been generated, you can switch your schema name back to 'dbo', if you are not planning any schema changes to the security tables]]> Mon, 04 Dec 2017 15:02:12 GMT https://www.codetrigger.com/forum/topic28-dont-want-the-security-tables-in-mvc-menu.aspx hi, I just generated an MVC test app just to see what came out, something very simple targeting an MSSQL db with only two tables. The generations was successful but when I try to build I get this errors. about 180 error related to Identity roles and such things. I need a hint on how to go about it. Thanks.


>>
Hello

Have you specified a 'schema name' in the CodeTrigger data source tab? If you do, it will only generate code relating to that schema. If this is the case, either enter 'security' as the schema name to build only the missing security pieces, or leave the schema name field blank to have the option of building everything
>>

Thank you. I had 'dbo' as the schema and that's why security did not generate. Now it does fine. However, I do not want the security tables to show on the menu when it generates. How do I make them not visible but still generate the needed code to compile successfully?Thanks
edited by migrator on 12/4/2017]]> Mon, 04 Dec 2017 15:01:29 GMT https://www.codetrigger.com/forum/topic27-lookup-tables-result-in-no-edit-code-functionality.aspx Hi,
This can be resolved by changing the db schema in one or both of the following ways, and re-running the code generation:

(1) Creating a new single column on the table as the primary key, perhaps an auto incrementing identity column
(2) In the case of a lookup table that only has reference columns eg TABLE (FK1, FK2), try making adding an extra non-reference column eg TABLE (FK1, FK2, [DESC])

Then re-run code generation, and the issue will be resolved.


If you are not authorised to change the db schema for some reason, then you will have to manually extend the generated classes, by creating extension partial classes to the DAO and BO classes, with edit methods.
This should not require you to make changes to the actual files generated by CodeTrigger, as your extended partial class code will be in extra files, perhaps in an 'extension' folder. However if you do change the code in the generated files,
make sure you 'escape' those files in the advanced options 'escaped files' list, so that your changes are not overwritten.]]> Mon, 04 Dec 2017 14:58:46 GMT https://www.codetrigger.com/forum/topic27-lookup-tables-result-in-no-edit-code-functionality.aspx Thanks for your quick response. I just checked and yes, one had two pk columns. Do you have a sample code or suggested way to go about generating the code for these multi-key tables? Or do I just have to modify it myself manually? Thanks again.]]> Mon, 04 Dec 2017 14:58:20 GMT https://www.codetrigger.com/forum/topic27-lookup-tables-result-in-no-edit-code-functionality.aspx Hi, Edit Links/code is/are generated when a table has a simple primary key, and NOT ALL the columns in the table are in the primary key. For example, lookup tables which contain two columns, but both of the columns are part of the primary key, will not be treated as editable, by the generated UI code]]> Mon, 04 Dec 2017 14:58:03 GMT https://www.codetrigger.com/forum/topic27-lookup-tables-result-in-no-edit-code-functionality.aspx Hi I just generated code for two simple tables and one came out with edit,delete links per row but the other one did not. What determines when these update links show. Both tables have PK columns defined. Thanks, José]]> Mon, 04 Dec 2017 14:57:01 GMT https://www.codetrigger.com/forum/topic26-app-key-doesnt-exist-in-appsettings.aspx When you hit the red button to generate code, depending on what options you have chosen, you might get a 'Things to Do' tab next to your 'Results' tab. This will normally tell you whether you need to copy a config setting, although in other cases it does it for you automatically.

In any case, search for a file called something like 'generated.config' . This will contain the appSettings that you need to copy into your WPF app.config file, or since you are using WCF, it needs to be copied into the web.config of the WCF service]]> Mon, 04 Dec 2017 14:53:06 GMT https://www.codetrigger.com/forum/topic26-app-key-doesnt-exist-in-appsettings.aspx Hi, First of all, congrat's for your Product: really friendly. Need your help with using the CriteriaAPI, thru a WPF app with WCF Service. I'm actually trying to use the CriteriaAPI to execute a custom query to a Business object. The request is pretty simple, I need to get the ID of a data with a particular text value. I always have an exception throwed, saying my AppKey (connection string) doesn't exist in appSettings. Need your help on that. Regards]]> Mon, 04 Dec 2017 14:52:39 GMT https://www.codetrigger.com/forum/topic25-postgresql-support.aspx Hi, Thanks for the suggestion! We'll put it on the suggestion board for future consideration.]]> Mon, 04 Dec 2017 14:51:02 GMT https://www.codetrigger.com/forum/topic25-postgresql-support.aspx Hi, Why not? Its more options to choose from for your customers, and hence greater value. I recommend you should do it.]]> Mon, 04 Dec 2017 14:50:15 GMT https://www.codetrigger.com/forum/topic25-postgresql-support.aspx Hi, There is currently no plan to add explicit support for postgreSql to CodeTrigger.]]> Mon, 04 Dec 2017 14:49:52 GMT https://www.codetrigger.com/forum/topic25-postgresql-support.aspx Thank you. How soon will you have support for PostgreSQL?]]> Mon, 04 Dec 2017 14:49:33 GMT https://www.codetrigger.com/forum/topic25-postgresql-support.aspx Hi, CodeTrigger does not support PostgreSQL at this time]]> Mon, 04 Dec 2017 14:49:09 GMT https://www.codetrigger.com/forum/topic25-postgresql-support.aspx Thank you for creating such a marvelous product. My question how can I get codetrigger to create database classes for PostgreSQL database. I know it supports MySQL, but I want to use it with PostgreSQL for a project.]]> Mon, 04 Dec 2017 14:48:29 GMT https://www.codetrigger.com/forum/topic24-autofac-rd-party-logging.aspx Looking at the sample, you would only need to edit 2 or 3 base classes or so to add your custom log4net handling code into the empty methods that have already been provided.




Regarding Autofac, this is somewhat more problematic as i dont immediately see the value, it seems to go against the grain of CodeTrigger, which is more or less a replacement so you dont need Autofac...]]> Mon, 04 Dec 2017 14:15:54 GMT https://www.codetrigger.com/forum/topic24-autofac-rd-party-logging.aspx One of my clients has mandated the use of AutoFac, log4Net and Moq. Your tool accomplishes 70% of all the coding we require. [What to do about the rest]..


I am aware of how much your tool generates in this regard; I am just seeking the remainder to eliminate one area of development needs. Essentially, I am looking to amend your tool to function better at the data persistence layer in our environment. I am not sure how many of your clients fall into our category but your tool is not far from being an absolutely perfect code generation tool for my firm.]]> Mon, 04 Dec 2017 14:13:44 GMT https://www.codetrigger.com/forum/topic23-aspnet-identity-optional-in-the-mvcwebapi-wizard.aspx Hi
I thought id let you know that use of asp.net identity for authentication in the MVC wizard is now optional, as per feature request discussed above.
This is part of the latest CodeTrigger update that shipped last night. (4.9.2.1)]]> Mon, 04 Dec 2017 14:12:13 GMT https://www.codetrigger.com/forum/topic23-aspnet-identity-optional-in-the-mvcwebapi-wizard.aspx First allow me to echo I have found CodeTrigger to be one of the most carefully constructed, deliberate and useful tools available in the domain of code generation. If there is one "limitation" of the product I have found thus far is the requirement to use .Net Membership while generating the MVC/API example. While not difficult, removing the code adds to development time to the point where it is more cost effective to not use your tool. One custom modification I would request is to add some process step to disable generation of such code.]]> Mon, 04 Dec 2017 14:11:32 GMT https://www.codetrigger.com/forum/topic22-using-criteriaapi-queries-across-the-wcf-boundary.aspx Hi
CriteriaApi does not work across the WCF boundary. In this case ordinary search is implemented using the less powerful 'SearchObjects' mechanism.
You can however have your own custom method on the WCF interface which is implemented in the server side with CriteriaApi]]> Mon, 04 Dec 2017 14:04:25 GMT https://www.codetrigger.com/forum/topic22-using-criteriaapi-queries-across-the-wcf-boundary.aspx Hi, We actually trying to use the CriteriaQuery API with the WCF service and we are not able to acheive that. We are calling the WCF service (located on a server) with a WPF app. We tryied to create custom Class into the CodeTrigger Business Layer, but we are not able to see it thru the service. Can you help us on that? Thanks]]> Mon, 04 Dec 2017 14:04:00 GMT https://www.codetrigger.com/forum/topic21-generating-code-from-sparxsystems-ea-data-models.aspx Hi
Thanks for your email. I do understand this feature request, indeed we had it as a possible on our dev board for a while before dropping it. I will put it back on there for further consideration. However, the reason it was not implemented as such previously was because
(a) it would introduce a different wotkflow between EA CodeTrigger and Visual Studio CodeTrigger
(b) Considering that the only difference you would see between successive iterations of changing your model and regenerating with CodeTrigger would be additional menu items (if you added a new table) or an extra column on the grid (if you added an extra field to model), this did not provide a compelling value add to the iterative process.
(c) Some elements in the code are dependent on the exact flavour of the database, ie the code generated to support Skip and Take record paging is different depending on the database version. Therefore the user would be required a more complete database model than otherwise might be the case.

Therefore, although it is an attractive feature, for these reasons it is yet to pass our prioritisation and cost benefit analysis.

I will keep you informed if any decisions are taken about this.]]> Mon, 04 Dec 2017 14:02:17 GMT https://www.codetrigger.com/forum/topic21-generating-code-from-sparxsystems-ea-data-models.aspx CodeTrigger (CT)generates code from an existing implemented database. The value that the CT EA Add-In may deliver is the ability to generate an application from a relational data model in EA without a connection to a database. The reason for this request is simply that it brings the design of the data model itself into the iterative design cycle. There is a general assumption that the data model design and the database schema is fixed but in my experience, its development goes through several cycles which change may also be influenced by what the users see in the forms.


There is also an assumption that most of your customers have an existing database. In fact I see your tools enabling the creation of next generation line of business applications from industry models. I should know as my day job is the development of corporate and industry models in the Aviation industry. I work for an Airport. In this scenario, the tools required include the Sparxsystems EA, CT for EA and Visual Studio. EA holds the corporate information models and the relational data models. The CT for EA generates the application from the models in EA. Visual Studio builds and runs the application. The process is model--> generate --> build --> review with end users. This process eliminates interaction with a database in the early iterations of application development. When the end user is happy with the prototype forms, the developer may then generate the database schema from the final data model, create the database, populate it with data and test.


The change in process and the productivity gain delivered by this approach and supported by CT for EA is the source for value To achieve the functionality described, CT for EA will be getting its schema information from the EA database. I am happy to work with you to test this functionality]]> Mon, 04 Dec 2017 14:01:40 GMT https://www.codetrigger.com/forum/topic20-naked-object-pattern.aspx Hi
Although CodeTrigger doesnt explicitly support the Naked Objects pattern, after a brief analysis it appears that the approach taken by CodeTrigger is compatible with the pattern as observed in some of the literature online.
However you might find that the sample UI's do not provide much UI centric support for managing relationships and collections which you may (or may not) find in software provided by Naked Objects framework tool vendors.

It would be interesting to know how you get on with this approach should you decide to proceed with implementing such a pattern using CodeTrigger.]]> Mon, 04 Dec 2017 13:59:33 GMT