Hi,
With Insert, Update and Delete methods but without a Select method, LinqDataSource control looks just like a chair with only three legs! Such a powerful and flexible control is used to get connected to a DataBound control like GridView, while it could excel in many scenarios if it had a Select method! For example, it [...]
Posts Tagged ‘ADO.NET’
Implementing a 3-Tier architecture with C# – Part 5
Posted in ADO.NET, ASP.NET, Architecture, C#, tagged 3-TIER, 3Tier, ADO.NET, APPLY, Architecture, ASP.NET, ATTRIBUTE, BUSINESS, BUSINESS CHECK, COMPLETE, CUSTOM, DATA ACCESS, grid view, IMPLEMENT, LAYER, LAYERED, maximumRowCount, N-TIER, NTier, object data source, ObjectDataSource, presentation, startRowIndex, SYSTEM, TRANSACTION, TRANSACTION SCOPE, UI on July 22, 2008 | 3 Comments »
Hi back,
In this post we will finalize the implementation of our 3-tier asp.net architecture, by developing a Web-based presentation layer.
So far, we have developed the data access and business layers. The implementation of UI, consists of methods and approaches for handling business and crud operations thorough a Web UI. In fact, there are several ways [...]
Implementing a 3-Tier architecture with C# – Part 4
Posted in ADO.NET, ASP.NET, Architecture, C#, tagged 3-TIER, 3Tier, ADO.NET, APPLY, Architecture, ASP.NET, ATTRIBUTE, BUSINESS, BUSINESS CHECK, COMPLETE, CUSTOM, DATA ACCESS, IMPLEMENT, LAYER, LAYERED, N-TIER, NTier, SYSTEM, TRANSACTION, TRANSACTION SCOPE on July 18, 2008 | 2 Comments »
Up to now, we have finished implementing the data access layer. However, we can reduce the dependency between the deriver DAL classes and Web.config file. As you remember, we have specified the DB provider name in Web.config file so that DAL classes must have access to this file to read the provider name. Another method [...]
Implementing a 3-Tier architecture with C# – Part 3
Posted in ADO.NET, ASP.NET, Architecture, C#, SQL SERVER, tagged 3-TIER, 3Tier, ADO.NET, Architecture, ASP.NET, C#, FirstReturnedRecord, IDENTITY, N-TIER, NTier, PAGING, ROW_NUMBER, SCOPE_IDENTITY, SQL SERVER, SQL SERVER 2005, StoredProcedure, TIER, UpdateRowSource on July 15, 2008 | Leave a Comment »
The Fill method we have developed so far, executes the Select command on the underlaying server and picks up RowCount records from startRowIndex position. For example, if Select * from Person returnS 20 rows, and startRowIndex is 0, only the first RowCount records will be fetched. This means that the complete result set will be [...]
Implementing a 3-Tier architecture with C# – Part 2
Posted in ADO.NET, ASP.NET, Architecture, C#, tagged 3-TIER, 3Tier, ADO.NET, Architecture, ASP.NET, C#, DbCommand, DbConnection, DbDataAdapter, dbProvider, DbProviderFactory, N-TIER, NTier, System.Data.Common on July 14, 2008 | 3 Comments »
Hi again,
Let’s keep on going and work on the Data Access Layer. The DAL layer we are going to design can be used with, theoretically, any sort of RDBMS because it will take advantage of ADO.NET generic classes. For this reason, I have written a base class for DAL classes and have placed in [...]
Implementing a 3-Tier architecture with C# – Part 1
Posted in ADO.NET, ASP.NET, Architecture, C#, tagged 3-TIER, ADO.NET, Architecture, ASP.NET, BUSINESS LAYER, COMMON LAYER, DATA ACCESS LAYER, DATASET, DataTable, DECIPLINE, ENTITY, N-TIER, OOD, TYPED on July 12, 2008 | 6 Comments »
Hi again,
Nearly two years a go I probed Internet to find out a good reference architecture for my ASP.NET applications. What I meant GOOD ARCHITECTURE was an architecture that:
IS FAIRLY SIMPLE
IS BASED ON N-TIED ARCHITECTURE
IS PRODUCTIVE
IS EASY TO IMPLEMENT
DOES NOT NEED A NY 3rd PARTY CLASSES (I.E. NHIBERNATE)
CAN BE USED FOR A WIDE RANGE [...]
DataTable.Compute method is lovely…
Posted in ADO.NET, C#, tagged ADO.NET, AGGREGATE, C#, COMPUTE, SUM on June 8, 2008 | 7 Comments »
For some reasons I do like to use DataSets (and Datatables) rather than DataReaders or other sort of IList collections to hold a list of records. Especially, typed DataSets are very helpful and am intended to write some articles about exploiting them later in this weblog. For example we can fill DataTables’s data/metadata by retrieving [...]
