9 comments found.
This not best practice solution for MicroService with alot of the bugs: Please fix “return reader.GetInt32(“TotalRecord”);” by change this on “return reader.GetInt32(“TotalCount”);” , the postman_import_file.json need update to V2 …
Thanks for ur feedback 1. There is template solution added which cna be modified to make best practices according to u. But u can also suggest me what is the best practices according to u nd i can look into it (skype: gyanverma2) 2. Postman file is v2 version.. let me chk it again if its having any issues 3. TotalRecord – let me check this why u r having problem on this.
Any suggestion nd bugs are always welcome thats they way we can improve the tool nd make it useful. Update u with my findings or update very soon via ur email
hi, is the application source code included? i would like to modify the app.. (the application code not the generated code)
no its not included. you can suggest if u have any geric request. or modify the template to generate according to ur need.
i want to generate Kendo-Ui and Syncfusion codes, but probably you wont do it.. is source code still not included in the extended license?
But this tool is for rest api generation not UI. Not the source code is not included in any possible way.
thats sad news
Is it possible to get Entity Framework, so instead of Quires it use Entity Framework?
No for now, Entity framework has alot of issues.. and with new version of .net u need to rewrite alot of stuff.. but u can add ur own DB Context in the same generated project.
inviled active
Can we quickly connect and check on skype: gyanverma2
very good tool. This tool saves me a lot of time. 
Thanks for your feedback.. this way we can make the tool more useful.
Hi there, would like to know if source code include? Or do you have project that create VB solution? Thanks.
Yes the Generated solution source code you will get. No VB solution is not there.
Thanks for reply, I mean the source code of this application is included? if no VB version then I need to modify the source code for generate VB results.
No source code is not included in that way.. but you can try modifying the template to use in VB project. There is a solution template with variables if u can modify that it will be cool. Add me on skype gyanverma2 I will send you just the template
it’s possible to do with MS SQL server?
No, this one is with MySQL
So, It’s allow to modify the code by our-self to get with MS SQL?
It will generate the code with MySQ db then u can try to change the connection to MS SQL manually. (May be little code also u hv to change)
Hi, source code for tools not included?
I acquired today, when generating the first system, I had some problems, the primary key in the interface always generates as “int”, even if the table is long or string, (in the model it generates right), I have a table with primary key composed of two fields , did not recognize and stated that the primary key does not exist, the expectation was to recognize the two fields and in the delete and update use these two fields.
Yes that should be the correct behaviour. Let me check locally and update you. You can also add me on skype gyanverma2.
updated the code, Please download and test. If still any problem ping me in skype or email I will look in details specific to your table.
Now it is assembling the right type, when the primary key is formed by only 1 field.
When the primary key is formed by 2 or more fields, see that it generated without parameters:
public ActionResult Put(, AcessosModel model)
{
try
{
}if (ValidationResult.IsError)
{
return BadRequest(new APIResponse(ResponseCode.ERROR, "Validation failed", ValidationResult));
}
return Ok(Manager.UpdateAcessos(, model));
}
catch (Exception ex)
{
return StatusCode(500, new APIResponse(ResponseCode.ERROR, "Exception", ex.Message));
}I expected to have generated: public ActionResult Put(String field1, String field2, AcessosModel model) return Ok(Manager.UpdateAcessos(field1, field2, model));
Or public ActionResult Put(ClassFiels primaryFields, AcessosModel model) return Ok(Manager.UpdateAcessos(primaryFields, model));
Where ClassFiels is Struct and contain both string fields.
another problem in the new version, the “string” parameter should not be within DataAccess.GetApartamentosByID
see the generated code:
public APIResponse GetApartamentosByID(string cdapar) { ... }
var result = DataAccess.GetApartamentosByID(string cdapar);In the template “manager.txt” the same flag “{primaryKeyList}” is used to create the parameter and to pass it on. in the transfer it has to be just the name of the variable
public APIResponse Get{tableName}ByID({primaryKeyList}) { var result = DataAccess.Get{tableName}ByID({primaryKeyList}); if (result != null) { return new APIResponse(ResponseCode.SUCCESS, “Record Found”, result); } else { return new APIResponse(ResponseCode.ERROR, “No Record Found”); } }
about “When the primary key is formed by 2 or more fields, see that it generated without parameters:”, please ignore, I had deleted the keys by mistake, it works. But strangely it didn’t generate when the pk was bigint in the database.
The problem is putting the variable type in the method call, in the manager project. Sample:
var result = DataAccess.GetAcessosByID(string cdusua,string cdmenu);
Got u. Just need to change the key in template file. Will change it and update the tool. really appreciate for the feedback. Thanks
I continued testing the tool, I have one more correction to ask you.
When creating the route on the controllers, the parameters must be enclosed in braces or else the route does not work
for example: [Route(APIEndpoint.DefaultRoute + “Param1/Param1”)]
correct for: [Route(APIEndpoint.DefaultRoute + ”/{Param1}/{Param1}”)]
and I also have a question, in our projects we usually generate the main route path in the class and in the methods only the rest of the route, in the case of the previous example “APIEndpoint.DefaultRoute” would be for the class and the rest in each method, it is possible configure this in this tool?
one more problem, we use unsigned number in C # it would be uint, ulong, these types are being generated as int, long, compile normally, but in rumtime it generates conversion exception
Oo. If possible could u drop me sample database to test. It will help me to finalize it quickly.
Congratulations! Nice Work, GLWS
Thanks