All geek questions in one place

Create a data access tier for a small website

I am building my application in asp.net 3.5. I have to make my data access level in which I am doing the traditional method of receiving / updating data. This is a SqlConnection than SQLCommand than SQLadapter. Will there be another way to create my own DAL layer.

Specification.

  • My site is small. About 7-10 pages.
  • There are about 80 tables in the database.

What i know:

  • Linq to SQL - I do not want to use it because I do not quite understand the LINQ statement, and I need to quickly create an application. [3 days :-(] There is also a 100% chance that the table structure will be changed in the future.

  • Corporate library . It takes too long. a lot of time for me to integrate with my application.

Any other suggestion to create my data layer is fast ... fast ... and "NOT" dirty. Thanks in advance.

+3
source share
4 answers

How about using Codesmith ( free version 2.6 ) to create a simple set of data access objects from your database? Given the small number of database objects that you need for modeling, I think this would be a quick and easy way to achieve your goal, given the time constraints.

+2
source

LINQ to SQL. , , , , Strongly Typed Datasets Table Adapters, Visual Studio. , , .

. . . Visual Studio, , , .

0

LINQ, linq-to-sql . , , linq .

0

You can also consider SubSonic . It is relatively easy to implement and fairly intuitive to use. Recently, it was used in a small project, and despite some problems with the initial configuration associated with its work with MySQL, it coped quite well with data access.

0
source

Source: https://habr.com/ru/post/1791199/

More articles:


All Articles