When developers think of how to access data, many use the Entity Framework (EF), Dapper, NHibernate, or some other object-relational mapper (ORM). Each of these ORMs use ADO.NET to submit their SQL queries to the back-end database. So, why do we use ORMs instead of just using ADO.NET directly? Simply put, ORMs allow you to write less code. If each of these ORMs are simply wrappers around ADO.NET, can't you write your own wrapper to cut down the amount of code you need to write? Absolutely! This article describes a set of wrapper classes to make it simpler to work with ADO.NET. This article does not go into every line of code in the wrapper; it is intended as an overview of the functionality. The complete code for the data wrapper can be downloaded from the Fairway Technologies resource site listed at the end of this article.
A common task we face as developers is to take data from a database table and create a collection of entity objects. We have several methods to accomplish this task. You can build a DataTable or DataReader, loop through the rows, build a new object for each row, and write lines of code to transfer column data to each corresponding property. Another method is to use an object relational mapper (ORM) such as the Entity Framework, Dapper or NHibernate which performs these operations for you. Have you ever wondered how these ORMs build the collection? Well, wonder no more. This blog post will show you how it is done.
This is part two in a series of blog posts on using the WPF ListBox. In this post, you change a ListBox to display rows horizontally instead of vertically. You learn to change ListBox templates dynamically at runtime. Finally, you learn to pass multiple pieces of data from your data source to a converter class and have that class return a single piece of data to be displayed.
In the second of a two-part blog series, Michael will talk about how to deal with mid-sprint corrections. Previously in Part 1, Michael discussed useful tips for avoiding issues early in the sprint process. So, join Fairway Technologies’ General Manager Michael Krasowski for a few noteworthy sprint insights for managing an IT team.
If your enterprise is using a legacy data warehouse, chances are you are using technology that was initially created more than three decades ago. Most of these systems have been upgraded over time. However, many data warehouse providers have simply retrofitted older versions of an open-source technology. These systems lack the highly performant, elastic, and cost-effective qualities of data warehouse solutions today. If you are contemplating upgrading your enterprise’s data systems, allow us to introduce you to the benefits of Snowflake, the data warehouse solution that was built for the cloud.
We often have a one-to-many relationship in tables in a database. When you need to ask the user to select a parent value, then select a child value in a web application, you don't want to post-back just to refresh the child list. Doing so causes a flash on the page and can place the user back at the top of the web page. This is not the best UI experience for the user but can be remedied easily. In this blog post, you are going to learn to populate a drop-down list based on the selection in another drop-down list. The technologies used in this post are MVC, Entity Framework, Web API, jQuery, and Ajax. To try out the samples in this blog post, create an MVC application using Visual Studio.
For years, Teradata has provided a number of quality database solutions to enterprises. The company has various offerings including cloud options, however its core product was not built for the cloud. Since its release in 1979, data warehouse technology has evolved tremendously. For businesses that are still looking for the best solution out there, allow us to introduce you to the benefits of Snowflake, the data warehouse solution that was built for the cloud.
The WPF ListBox is a very versatile control. In this multi-part series of blog posts, you will be shown a myriad of ways to coerce the ListBox to work the way you want. You will learn how to create multi-row and column items with images, how to change the information displayed in each row dynamically, and how to present the list box horizontally. You will also learn to use data triggers, sorting, grouping,and filtering. In this post, you learn to add multiple rows and columns to each row of your list box.
Not long ago, a prospective client came to us to ask that we write up a proposal for designing the software components of a new consumer-grade medical diagnostic product that they were bringing to market. This device was going to be a simplified version of an existing system that had been in production for some time, so surely the requirements for the new product would reflect that pedigree and be relatively straightforward.
In this two-part blog series, Michael will first discuss useful tips for avoiding sprint issues early and secondly, in Part 2, he will talk about how to deal with mid-sprint corrections. So, join Fairway Technologies’ General Manager Michael Krasowski for a few noteworthy sprint insights for managing an IT team.