Click here to Skip to main content
15,891,033 members
Articles / Programming Languages / C#

Insight.Database - .NET Micro ORM - Part 2 - Executing And Carrying Out SELECT SQL Commands

Rate me:
Please Sign up or sign in to vote.
5.00/5 (5 votes)
11 Jan 2023CPOL2 min read 5K   43   6  
Using Insight.Database to Run and Complete SELECT SQL Commands (.NET Micro ORM)
In this post, we'll look at Select operations with Insight.Database using the conventional Micro-ORM method.

Views

Daily Counts

Downloads

Weekly Counts

License

This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)


Written By
Technical Lead HCL Technologies LTD
India India
Full stack developer with over 10.1 years of IT industry experience in Microsoft .Net & SQL on application Design, Development & Production supportProficient in building Web Applications using Microsoft .Net Core & Framework, C#, ASP.NET MVC & Web API, SQL Server, Micro ORM, Entity Framework, jQuery, Bootstrap, WCF and Dependency Injection.

• Strong knowledge in N-Tier architecture applications and SOA (Service Oriented Architecture) based services.

• Architecting applications with industry best practices, using SOLID DRY SOC design principles, Dependency Injection, Onion Architecture, and Aspect Oriented Programming for Logging and Repository Pattern for Database Communication.

• Expertise on developing MVC Application with best practices using Areas, Attribute based Routing, Responsive Web Design and jQuery with modular pattern.

• Expertise on using Tuples and DTO (Data Transfer Objects) for efficient and quick data transfer.

• Strong hands experience in writing test cases faster using Specflow (BDD), MSTest, Nbuilder, Faker and MOQ frameworks to achieve best code coverage.

• Worked on Security features using form and windows Authentication for web applications and token-based for Web API and role-based Authorization.

• Expertise on writing honest methods, refactoring code using Resharper/StyleCop to create clean, reusable, scalable code and improve performance.


Comments and Discussions