11 thoughts on “Database to full asp.net Mvc App – in 5 minutes”

1. why do you use Task in the api controller? any specific reason?
   can i remove these and use without task.
   public async Task ..
   ..
   var result = Task.Factory.StartNew(() => {
   …
   await result;

   LikeLike

   Reply

   1. The methods in the Api controller are designed to be fairly generic. In the simple case when only one ‘intensive’ operation is happening in the method,then the Task/async approach may have little or no impact. When you have multiple intensive processes to execute in the method, this approach would allow you to run them in parallel, thus each request to that method can potentially execute faster.
      Yes, absolutely you can remove these and use without Task/async.

      PS see the following links for further info on whether or not to use webapi async
      http://www.asp.net/mvc/overview/performance/using-asynchronous-methods-in-aspnet-mvc-4
      https://msdn.microsoft.com/en-gb/magazine/dn802603.aspx

      LikeLike

      Reply

      1. Thanks

         LikeLike

2. your exe is showing ORACLE 12c+ for Oracle Database.
   Our product database are the following on windows 7 64bit or 32bit :
   Server — Oracle 10g XE Server
   Client — Oracle 10g XE Client
   Can i generate the code for Oracle 10g XE?

   LikeLike

   Reply

   1. There are a couple of issues. Pagination and Identity
      (1) The new ‘Skip’ and ‘Take’ functionality to support paging is not implemented for versions < 12c, all else should be the same. Trying to use the Skip or Take functionality for versions < 12c will throw a 'NotImplemented' exception, so if you need some paging mechanism you will either implement your own paging scheme, or you will have to provide a workaround. If you search the generated code for '12c' you will see where the NotImplemented exception is thrown, and that would be a likely place for the workaround.

      (2) The identity tables created to support asp.net identity rely on auto generated primary keys. This is a new feature of Oracle 12, (IDENTITY field type/option). So it is likely that the auto generation of the identity tables by the MVC wizard will fail. However this is only done once on any database, so it might be possible to run the MVC wizard against a 12C database, inspect the schema of the identity tables, create a version of the tables in the 10g database, and then run the MVC wizard on your desired 10g db. This wizard process will then see that the identity tables already exist and will not attempt to recreate them. This is something you can try as a workaround (and obviously test that creating/editing/deleting users and roles works as expected) but officially the MVC functionality is only targeted at 12c+

      LikeLike

      Reply

      1. Thanks for the clarification. if i do not want pagination and identity means i can generate code. we just want to handle select/creating/editing/deleting master and detail with transaction.

         LikeLike

3. Thanks. i generated code below Oracle 12c like below
   choose DB to Multi-tier application -> tick data and tick business
   Now i want to use BO method in the WebApi with UOW.
   can i generate code using mySql Database and shall i take it web api controller from this project to oracle project. because our front end is angularjs.

   LikeLike

   Reply

4. i want to handle POS crud operation. our ui form contains all basic with detail finally save the record using post/put web api method.
   our model are OrderBasic – id,docid,docdate,customername, tablename, empname
   OrderDetail – id, orderbasicid, itemname, qty, rate, amount
   my post view model like the below:
   OrderVm – OrderBasic, List
   here how to handle transaction and rollback using UOW.

   LikeLike

   Reply

5. OrderVm – OrderBasic, List of OrderDetail

   LikeLike

   Reply

6. This is pretty straightforward, 3 steps – create the domain objects from the viewmodels (vms), queue up the operations in a UnitOfWork object, and commit. See illustration below. There has been some changes to the internal processing of transactions, so you should probably get the latest release 4.8.6.6 (28th June 2016)

   
           // POST: api/OrderBasic
           [ResponseType(typeof(OrderBasicVm))]
           public async Task PostOrder(OrderBasicVm orderBasicVm, OrderDetailVm[] orderDetailVms)
           {
               if (!ModelState.IsValid) { return BadRequest(ModelState); }
   
               var result = Task.Factory.StartNew(() =>
               {
                   IUnitOfWork uow = new UnitOfWorkImp();
   
                   /****queue up the transaction items*************************************/
                   var boOrderBasic = orderBasicVm.BOOrderBasic();
                   uow.Create(boOrderBasic);
                   foreach (var detailVm in orderDetailVms)
                   {
                       var boDetail = detailVm.BOOrderDetail();
                       /**get the new pk ids into fk tables/objects**/
                       uow.Create(new UnitOfWorkForwarder((Action)delegate { 
                       boDetail.Id = boOrderBasic.Id;}, null, null));
                       uow.Create(boDetail);
                   }
                   /***********************************************************************/
   
                   string err;
                   /****commit the transaction if all ok, rollback if not******************/
                   if (!uow.Commit(out err))
                   {
                       var resp = new HttpResponseMessage(HttpStatusCode.BadRequest) { Content = new StringContent(err) };
                       throw new HttpResponseException(resp);
                   }
                   /***********************************************************************/
                   return true;
               });
   
               await result;
               return CreatedAtRoute("DefaultApi", new { id = boOrderBasic.Id }, orderBasicVm);
           }
           

   If you are using the repository pattern to enable unit testing, then the approach is slightly different.
   Hope this helps

   LikeLike

   Reply

   1. Thanks

      LikeLike

      Reply