Skip to main content

Posts

Showing posts with the label ADO.NET

Batch queries, Multiple Result Sets and Parameterized Queries in ADO.NET

Requesting SQL Server for multiple results is a very common scenario while programming. Instead of asking for records with a single SELECT statement, you may find yourself want to retrieve multiple results in a single Query. For example, consider that you want to retrieve both information for a product and all it's related orders. One solution would be to query the database for Product info with a SELECT statement:
✔ Read More...
I guess you came to this post by searching similar kind of issues in any of the search engine and hope that this resolved your problem. If you find this tips useful, just drop a line below and share the link to others and who knows they might find it useful too.

Stay tuned to my blogtwitter or facebook to read more articles, tutorials, news, tips & tricks on various technology fields. Also Subscribe to our Newsletter with your Email ID to keep you updated on latest posts. We will send newsletter to your registered email address. We will n…

ADO.NET : Working with DataSet, DataTable, DataColumn, DataRow and DataRelations

Knowing to work with the offline ADO.NET classes such as DataSet and DataTable, is the Alpha and the Omega in ADO.NET before actually start queering real database data. You need to understand that ADO.NET divides it's classes in two major categories. The Connected and the Disconnected classes. The Connected classes are those that lets your retrieve and update data in your data sources. The most important classes of that category are the Connection, DataReader, DataAdapter classes. The Disconnected category classes, are those that lets you access and manipulate offline the data you have retrieved using the Connected classes. When you decide, you can synchronize the changes you made to the Disconnected classes, using the Connected ones again. The most important Disconnected classes are the DataSet, DataTable, DataColumn, DataRow, DataRelation classes. This is the second post of the series in ADO.NET category and I hope you have already read the first one, Introduction to ADO.NET.
✔ R…

Update & Delete Data using ADO.NET C# POCO Entity Generator with WCF Support

Update & Delete Data using ADO.NET C# POCO Entity Generator with WCF Support Introduction This article demonstrates one of interesting and most useful concept in Entity Framework Model - POCO Entity Generator with WCF Support Update & Delete. Question: What is POCO Entity Generator with WCF Support? In simple terms "It is a T4 template generator […]
✔ Read More...
I guess you came to this post by searching similar kind of issues in any of the search engine and hope that this resolved your problem. If you find this tips useful, just drop a line below and share the link to others and who knows they might find it useful too.

Stay tuned to my blogtwitter or facebook to read more articles, tutorials, news, tips & tricks on various technology fields. Also Subscribe to our Newsletter with your Email ID to keep you updated on latest posts. We will send newsletter to your registered email address. We will not share your email address to anybody as we respe…

Introduction to ADO.NET

If you aren't new to .NET development you will be aware that there are several different ways to access and manipulate database data. New developers always use the build in Visual Studio features such as SqlDataSource or EntityDataSource. These are very helpful features coming from .NET Framework allowing you to access your database with just a few clicks and let's be honest, they do work fine. Other developers prefer to use LINQ in the way we have seen in previous posts. All these techniques for sure let you access your data, writing less code and making less mistakes, since they use strongly data types. What you might aren't aware of, is that all these features have a drawback: most of their actions/commands are converted sometime in native ADO.NET code before they are actually executed. In other words, what you gain in simplifying code writing, you loose in performance since all commands have to be translated in lower lever code before executed. You might haven't se…

A Beginner's Tutorial for Understanding Transactions and TransactionScope in ADO.NET

This article is a beginner's tutorial for understanding what are transactions and how can transactions be implemented using .Net framework and ADO.NET for any ASP.NET web application or any other database driven application.
✔ Read More...
I guess you came to this post by searching similar kind of issues in any of the search engine and hope that this resolved your problem. If you find this tips useful, just drop a line below and share the link to others and who knows they might find it useful too.

Stay tuned to my blogtwitter or facebook to read more articles, tutorials, news, tips & tricks on various technology fields. Also Subscribe to our Newsletter with your Email ID to keep you updated on latest posts. We will send newsletter to your registered email address. We will not share your email address to anybody as we respect privacy.

This article is related to
C#,.NET,Architect,Intermediate,VS2010,.Net,Articles,Computer Tutorials,ADO.Net,Transactions in ADO.Net,Transactions,Trans…

Using the Entity Framework 4.3 in .NET Development

This article describes how to use the Entity Framework for building applications through a tutorial. The Entity Framework enables developers to create data access applications by programming against a conceptual application model instead of programming directly against a relational storage schema. The goal is to decrease the amount of code and maintenance required for data-oriented applications.

The end product will be a group of unit tests that use the Entity Framework to query and update the database. This code can be used in your data-oriented application for data access and updates. No ADO.NET code is used to communicate with the database. The objects that are returned are enumerable types that can be traversed using LINQ.
Read More...


I guess you came to this post by searching similar kind of issues in any of the search engine and hope that this resolved your problem. If you find this tips useful, just drop a line below and share the link to others and who knows they might find it u…

A N-Tier Architecture Sample with ASP.NET MVC3, WCF and Entity Framework

N-Tier software architecture can solve the following client/server system issues: scalability, security, fault tolerance and etc. In our previous article "N-Tier Architecture and Tips" we introduce the basic N-Tier architecture concepts and some practical tips. In this article, we try to elaborate a N-Tier architecture sample with ASP.NET MVC3, WCF and Entity Framework. In Java, usually there is a pre-defined way to achieve the N-Tier architecture: J2EE architecture, which uses session bean over entity bean for business and persistence layer, Java bean, servlet or JSP for the client presenter layer, Java Swing, HTML or applet as the client side. Therefore, for J2EE, different application are very likely implemented in very similar ways. However, in .NET, even though there are many tools and features available, there isn't any pre-defined way as J2EE does to guard how to implement the N-Tier architecture. As a result, there are too many inconsistent and existing ways to d…