System requirements

• VISUAL STUDIO

  • Irwsoft Data Framework Light Edition contains SQL-object mapper classes designed to help you work with SQL relational databases.

    Irwsoft Data Framework Light Edition is integrated within Visual Studio IDE and helps you manage database objects, table relations, data-class references and more.

  Let these tools generate your data access layer, saving you time and headaches. There’s something here for the simplest or most complex projects.

  • By Terrence Dorsey
  • 11/16/2015

  If your software development projects are anything like the ones I encounter every day, you spend a lot of time creating, saving, querying, moving, merging, and munging data.

  Last year I wrote “11 Visual Studio Tools to Simplify Data Access,” covering some of the more general tools and frameworks for creating and managing data. Back in 2011, my MSDN Magazine column, “Data Integration Tools and Resources,” covered data basics, tips, tricks, and other resources to get started using data with SQL, LINQ, Entity Framework, and more.

  Both of those articles are still useful. In this article I’ll take a look at some newer tools and extensions, specifically those that integrate directly with Visual Studio 2013 and 2015.

  CodeTrigger
  Let’s start out with the CodeTrigger Code Generator & ORM extension, by Exotechnic Corp., which combines a number of handy code-generation tools into a single toolset.

  CodeTrigger (see Figure 1) analyzes the schema of your data source and automatically builds business and data domain models. It also generates data domain classes and business domain classes includi

  ng typed lists, collections, stored procedures and interface definitions. The generated code includes support for dependency injection using Unity or Ninject, as well as logging and exception handling.

  Your source data can include SQL Server, Oracle and MySQL databases, and CodeTrigger can generate C#, Windows Presentation Foundation (WPF), Windows Communication Foundation (WCF), and SQL code for you for Windows Forms, WPF, ASP.NET, WCF services and more. The CodeTrigger extension integrates directly with Visual Studio 2010 through 2013. There’s also a standalone version available.

  Trial versions are available for both standalone and extension installs. See the CodeTrigger Web site for license information and pricing, IDE integration instructions, downloads, tutorials, and code samples.