Asset Management

**Why Migration?**

For .Net based projects, SQL Server may not the only choice when it comes to enterprise. Considering Microsoft licensing change from processor based to core based in 2012, its not the pocket friendly option any more and demand for other databases has increased.

That forces many of the enterprise applications to support various other databases which offer great security features and licensing options.

Due to increased demand, one has to migrate to Object-Relational Mapping(ORM) framework or equivalent implementation based on needs.

**ORM or Native Drivers:**

Native Driver based implementation expects dynamic switching/multiple code bases. So, new database support may require changes to code base.

We have evaluated two ORM frameworks **nHibernate** and **Entity Framework (EF6)**. We happened to choose EF6 considering better long term support for enterprise.

In my case, I have chosen EF6 with Code First approach. Code First approach enables us avoid database specific configuration files.


**Performance Results (Native SQL Provider vs EF6 ORM):**

- Performance tests are run on basic identical servers.

- ORM initialization is performed before running performance test.

![25k iterations Test Result.png](https://surya-soft.surya-products.com/strapi/uploads/25k_iterations_Test_Result_de492253af.png)

![50k iterations Test Result.png](https://surya-soft.surya-products.com/strapi/uploads/50k_iterations_Test_Result_2c1b9dfdbb.png)

![Select with Pagination Test Result.png](https://surya-soft.surya-products.com/strapi/uploads/Select_with_Pagination_Test_Result_6f737c2308.png)


**Advantages:**
- EF Providers from respective DB owners is a huge advantage

- Compiled queries with LINQ (Less run-time surprises)

- No manual SQL statements

- Automatic Query generation, which is SQL Injection Safe

**Disadvantages:**
- Performance cost is upto 2X of ADO.NET without ORM. This can be covered with few optimizations, but it does not match with native performance.

- No control over generation of query. This is acceptable, as long as support from providers is good. So far, Oracle, PostgreSQL and SQL Server seems very active and stable with latest releases.


Even though performance results are not encouraging, its features for multiple databases and fact that we can stick to one code base encouraged us to choose EF.

**Things to be taken care during migration:**

1. Unlike SQL server, most other databases are case-sensitive for table names and column names. In order to overcome these issues, we choose to create tables and columns by forcing case sensitivity same as Model.

2. In case your application uses Forms Authentication or similar which demands native providers. This part needs to be rewritten with a custom provider.

3. Free Style SQL queries has to be converted to LINQ. No more string based queries

4. Say No to most of the Stored procedures, as databases like PostgreSQL does not support them. By adding certain blocks, will force your app to stick to fewer databases.

5. For .Net applications, its common to use SSRS based Reports(Written in RDL). If that is the case, one has to convert all RDL based reports to RDLC reports.



**Summary:**

Essentially, EF6 has performance overhead compared to native drivers. But, it provides a great way to code using LINQ and achieve database portability. Learning curve for EF6 is minimal for a person who is familiar with LINQ.

Happy Coding!






A story written with experience of migrating .Net codebase from SQL Server to Multiple Databases support.

medium_Regtech.jpeg

small_Regtech.jpeg

thumbnail_Regtech.jpeg

Regtech.jpeg

ADO.NET Native to EF6 Migration

Risk Management

Reduce Risk and Improve Transparency – One of the primary benefits of regulatory reporting is that it helps to reduce risk and improve transparency in banking activities. This is because regulatory reports provide detailed information about a bank’s assets, liabilities, capital adequacy, liquidity position, market risk exposure and more. Having access to this data allows regulators to monitor a bank’s performance on an ongoing basis, ensuring that any potential risks are identified quickly and appropriately managed. 

Enhance Compliance – Another benefit of regulatory reporting is that it can help banks to enhance their compliance with applicable laws and regulations. By providing detailed information about a bank’s activities, regulators can ensure that banks are operating within the parameters established by legal frameworks in place, helping to protect consumers from any potential abuses or misuses of funds. Additionally, having clear data on hand also makes it easier for banks to identify any areas where they may be out of compliance with regulations so they can take action quickly and effectively. 

Improve Efficiency – Finally, another benefit of regulatory reporting is that it can help banks become more efficient in their operations. This is because regulatory reports provide detailed data on a range of topics such as asset management strategies, liquidity positions, capital adequacy levels and more. Having access to this information can help a bank make better decisions when it comes to its operations as well as identify areas where improvements could be made in order to increase efficiency across the organization. 

Conclusion: 
Regulatory reporting is an essential part of banking operations as it helps ensure compliance with applicable laws and regulations while also providing valuable data about a bank’s performance which can be used for decision making purposes. Additionally, having access to detailed reporting can help reduce risk while increasing transparency within banking activities. As such, regulatory reporting has numerous benefits for banks which should not be overlooked if they wish to maximize efficiency across their organization while reducing potential risks associated with their operations.

Regulatory reporting is a critical part of banking, as it helps to ensure that banks are following the rules and regulations set out by governments and other regulatory bodies. It helps to keep banking activities safe and transparent, which in turn can help banks to better serve their customers. In this blog post, we will look at some of the benefits of regulatory reporting for banks. 

medium_AdobeStock_480329143_Preview.jpeg

small_AdobeStock_480329143_Preview.jpeg

thumbnail_AdobeStock_480329143_Preview.jpeg

Happy client

The Benefits of Regulatory Reporting for Banks 

First-Capital-Bank-thumb-1280x720-removebg-preview.png

First Capital Bank

MicrosoftTeams-image__1_-removebg-preview (1).png

NBS Bank

unnamed__1_-removebg-preview.png

MicrosoftTeams-image__2_-removebg-preview.png

Cogebanque

download (1).png

CUB 

download (2).png

HDFC Bank

SIDBI_LOGO.png

SIDBI

NKGSB Bank.png

NKGSB

download-removebg-preview (2).png

Saraswat Bank

Shivalik_Bank-removebg-preview.png

Shivalik

aditya-birla-capital-limited-removebg-preview.png

Aditya Birla Capital

Axis_Bank_logo.svg

Axis Bank

belstar-investment-and-finance-private-limited_owler_20210830_161832_original.png

Belstar

CDH_Investment_Bank.jpg

images.png

CSB Bank

DB-LOGO-300.png

DOHA Bank

janalogo.png

JANA SMALL FINANCE BANK

thumbnail_Group_22804_5b2c73eb43.png

SI Bank

Indian_Bank-removebg-preview.png

Indian Bank

download__1_-removebg-preview.png

AU small finance bank

DCB_Bank-removebg-preview.png

DCB Bank

2560px-RBL_Bank_SVG_Logo.svg-removebg-preview.png

RBL Bank

SBM_Bank-removebg-preview.png

SBM Bank

Karur_Vysya_Bank.svg

KARUR VYSYA BANK

NPCI-Logo-removebg-preview.png

NPCI

Know more about the valued clientele from across industries that we service with our comprehensive solutions.

CLIENTS SERVED

Get unique insights into our deep domain expertise with this comprehensive storehouse of knowledge and learn how we can accelerate your business efficiencies.


Blog

Contact Us

Download

Reach out to know more

Lorem ipsum dolor sit amet consectetur adipisicing elit. Possimus ea quaerat perspiciatis rem dolorem numquam ut, vero soluta odit ratione consequuntur natus iste.

Categories

About

Leadership

Journey

Clients

Insights

Customer Stories

Resources

Blog

Careers

Culture

Jobs

Fintech

DigiTech

Contact

Sitemap

Cookie Policy

FAQ