Please find below architecture diagram, which one of my client has proposed for a project. Project is quite big size and currently its using SOA with ADO.Net(Stored procedures) for database operations.
I am little reluctant to use messaging service, as it will add extra layer and may create additional perfomance issues.
Please give your inputs on my below queries
(1) Main issue we are facing with current architecture - when a long running stopred procedure is running it slows down other operations as well. That is why we have separated one big database into multiple databases. - As application logic is quite complex currently we have stored procedure which have complex queries.
(1) would it be possible to use EF and replace ADO.Net completely. How to replace stored procudures having complex(or big) queries involving around 20 tables.
(2) How to maintain transections when we have multiple databases, I think this would be very difficult.
(3) If possible would you please suggest me some sample or application using similar architecutre, so that I can create a pilot application and test it with my current database.
Aucun commentaire:
Enregistrer un commentaire