I have an existing project running in the ASP.NET technology. Currently, the entire business logic calculation is happening in the database sProcs (MS SQL Server). And at times, the application becomes slow when it being used by plenty of users during the busy time of the day.
Now we want to move out some of the business logic processing away from the DB and perform it in the business layer (C#) side. I am trying to understand how do i get the data from the database and perform some calculation on it and then again save the furnished data back to the DB.
I can get the raw data from the DB , then serialize into the XML and then pass this XML to the BL layer. In the BL layer, XML will be De-serialized into the strongly typed business objects. And then using the Linq-to-Object, i can perform some operations (such as Sum, Avg etc) on it.
Please advise with your suggestions.