Traditional yet Powerful : Data Access Layer for ASP.Net(moretechtips.net)

submitted by MikeD1(290) 3 years, 1 month ago

This is a complete example of creating Data Access Layer(DAL) using the traditional yet powerful "Object to Relational mapping model" or "Custom Entity Classes" that support Paging too.. read more...

add a comment |category: ASP.NET |Views: 54

tags: OOP DAL Paging ADO.NET ASP.NET another

How to use custom audit fields with SubSonic(jamesewelch.com)

submitted by jamesewelch(2275) 3 years, 4 months ago

SubSonic uses a few audit fields by default - you don’t need to write any code. However, the field names that are used are coded into the source code. You can modify the source code and generate a new assembly, but if you’re like me and would rather not edit the source code (so you don’t need to update the code at every release), then you’ll be looking for an alternative approach. Three options are discussed: 1) Modify SubSonic source code, 2) Use partial classes for each table, 3) Create a custom template and base class read more...

2 comments |category: Database |Views: 214

tags: SubSonic DAL C# Database OpenSource another

How to perform an aggregate query using SubSonic 2.1’s SqlQuery(jamesewelch.com)

submitted by jamesewelch(2275) 3 years, 7 months ago

One of the new features is the addition of the SqlQuery class and it’s ability to perform aggregate queries (along with many other features). Shows example of SQL syntax versus SubSonic's SqlQuery aggregate coding to perform SQL queries. read more...

add a comment |category: Database |Views: 257

tags: SubSonic DAL ORM Database SQL another

Fitting Linq To Sql into a real world datalayer(codethinked.com)

submitted by justin_etheredge(8539) 3 years, 11 months ago

A quick guide on using POCO with Linq To Sql and how to integrate it with your business layer without having to move everything into one namespace or inherit from any specific classes. read more...

add a comment |category: Linq |Views: 29

tags: CodeThinked DAL LINQ another

LightSpeed 1.2 Released(mindscape.co.nz)

submitted by simonech(10.1k) 4 years ago

Mindscape released a new version of LightSpeed, their OR mapper. There are quite a lot of new features like more mapping options and a cool debugger visualizer that shows the queries being executed to get the data from the DB. read more...

1 comment |category: Products |Views: 25

tags: DAL LightSpeed ORM Database Products another

Build a complete Stored Procedure based Data Access Layer ... Part 2(blog.zacksfiasco.com)

submitted by ormico(150) 4 years ago

Build a complete Stored Procedure based Data Access Layer using Code Generation - Part 2 read more...

add a comment |category: Database |Views: 35

tags: TSQL DAL ORM Database ADO.NET another

Build a complete Stored Procedure based Data Access Layer ... Part 1(blog.zacksfiasco.com)

submitted by ormico(150) 4 years ago

Build a complete Stored Procedure based Data Access Layer using Code Generation Part 1 read more...

add a comment |category: Database |Views: 65

tags: TSQL DAL ORM Database ADO.NET another

Fluent Ordering/Paging with LightSpeed(mindscape.co.nz)

submitted by turtlespin(634) 4 years, 4 months ago

A short overview showing how the Query object in LightSpeed lets you apply aspects such as Ordering and Paging easily and using a Fluent interface style when working with the domain modeling framework and O/R Mapper, LightSpeed. read more...

add a comment |category: Database |Views: 15

tags: product DAL Database another

Create Data Access Layer Using Repository Factory Screencast(davidhayden.com)

submitted by rpatterson(745) 4 years, 4 months ago

This Screencast shows one how to generate business entities, stored procedures, and repository factory classes to create a data access layer for your web and winform applications. read more...

add a comment |category: Patterns |Views: 160

tags: DataAccess DAL Patterns another

How to Design a Great, yet Simple Data Layer in .NET(ajaxninja.com)

submitted by Aaronontheweb(1140) 4 years, 4 months ago

The article includes a code sample at the end on how to design a very simple yet elegant data layer (or data tier) in ASP.NET. Make sure you check out the IBusinessEntity interface. read more...

add a comment |category: ASP.NET |Views: 61

tags: DAL IBusinessEntity ASP.NET nTier another

SubSonic: Auto-generate A DAL For Class Library and Win App Projects(blog.wekeroad.com)

submitted by ussherm(5285) 4 years, 7 months ago

Rob walks us though setting up a call to SubSonic's command line utility to auto-generate the DAL during project build. read more...

add a comment |category: Visual Studio |Views: 216

tags: DAL SubSonic another

The 411: Stored Procedures, Views, and ORM(blog.wekeroad.com)

submitted by BrianRichards(315) 4 years, 8 months ago

Choose the best DAL for the situation and don't get wrapped up in zealotry read more...

add a comment |category: Architecture |Views: 11

tags: DAL ORM another