Showing posts with label ADO.NET. Show all posts
Showing posts with label ADO.NET. Show all posts

Sunday, December 1, 2013

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:


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

Sunday, June 23, 2013

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.


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

</ span>C#,.NET,Architect,Intermediate,VS2010,.Net,Articles,Computer Tutorials,ADO.Net

Monday, June 17, 2013

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 […]


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

</ span>C#,.NET,Architect,Intermediate,VS2010,.Net,Articles,Computer Tutorials, MVC, ADO.NET, POCO Entity Generator, WCF

Sunday, June 16, 2013

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 seen this drawback in simple transactions with just a few data in your database but giving a try your code in a great amount of data trust me, you 'll get the filling. This post, as it's title says is a brief introduction to ADO.NET Framework. If you need to boost your application's performance while accessing great amount of data, ADO.NET is what you need to use. I personally believe that using ADO.NET is so important that I created a separate category for this feature in my blog. There will be a lot of other posts relating to ADO.NET so stay in touch if you want to get the most of that.


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

</ span>C#,.NET,Architect,Intermediate,VS2010,.Net,Articles,Computer Tutorials,ADO.NET

Saturday, January 5, 2013

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.


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,TransactionsScope,TransactionScope in ADO.NET

Tuesday, September 11, 2012

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 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, Dev,ADO.NET,LINQ,Intermediate,C#4.0,.NET4.5

Monday, August 27, 2012

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 do this. Some are good; some are bad. This article tries to introduce a decoupled, unit-testable, deployment-flexible, implementation-efficient and validation-flexible N-Tier architecture in .NET. What we achieved here is to put some well-known nice tools and features in .NET together and come up with a workable solution. Because there is too much to cover in one article, we will mainly concentrate on business and persistence layers of N-Tier architecture in our sample solution, but will still briefly touch other layers too. In order to understand better this article, we suggest you to read first our previous article on the basics of N-Tier architecture here. As our previous article, this article is also based on the assumption that a team has a full control over all layers of the N-Tier architecture.

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

ASP.NET,Architect,Dev,ADO.NET,WCF,Design,Beginner,Intermediate,Advanced,C#,.NET,Architect

LinkWithin

LinkWithin

Like Us On Facebook and Receive All Updates!

You can also receive Free Email Updates:

Powered By Tutorails