Stack Overflow
Stack Overflow

Questions tagged [data-access]

Data access typically refers to software and activities related to storing, retrieving, or acting on data housed in a database or other repository.

Data Access is simply the authorization you have to access different data files. Data access can help distinguish the abilities of Administrators and users. E.g. Admins may be able to remove, edit and add data, while a general user may not be able as they don’t have the access to that particular file.

327 questions
2
votes
1 answer

Reusing Slick's DB driver code in data access layer

I'm trying to wrap my head around data access with Slick 3.0. After consulting various github examples, I've came with following design. A singleton Slick object where the DataSource and Driver instances are injected class Slick(dataSource:…
David Siro
  • 1,826
  • 14
  • 33
2
votes
4 answers

Need help locking my code for SQL Server

We want to build into our software the capability to build SQL queries freehand (currently cannot do so with our software), but need to be able to lock it down so that users cannot make any changes, only select data from certain tables. Are there…
Tom A
  • 1,662
  • 2
  • 23
  • 41
2
votes
1 answer

DAL/BLL and Client/Server: Should the client use BLL or DAL objects for presentation? Or maybe another layer (data transfer object?)

I'm writing a client/server system. The server has a DAL/BLL design. The client is responsible for presenting the data objects and providing dialogs and wizard to allow the user to update these objects (i.e. adding/editing a user). Initially I…
Mark
  • 1,296
  • 13
  • 28
2
votes
1 answer

Sharing connection and transaction in a Data Access Layer

I'm building a Data Access Layer for my asp.net application. I would like to be able to share connection between different classes in order to manage transaction, but I don't know how to do that. Example: I have 2 classes, Order and OrderDetail. I…
opaera
  • 21
  • 2
2
votes
0 answers

Increase Azure Database DTU in range of hours

i have a system who uses database of Azure and in the morning(6h~12h) the access is too high, DTU arrive to 100%, but the rest of the day DTU stabilizes in 20%. I want to known if have a way that i can schedule to increase DTU only in the morning,…
Jonathan Molina
  • 703
  • 6
  • 13
2
votes
2 answers

(DevForce vs OpenAccess vs LLBLGen) vs Entity Framework 4 & CTP4

Putting free open source ORM/DataAccess/Modeling tools (like NHibernate) aside, what do some similar commercial tools offer beyond what the current Entity Framework 4 (plus CTP4) offers. Commercial ones in mind are Telerik's OpenAccess, IdeaBlade's…
Tony_Henrich
  • 42,411
  • 75
  • 239
  • 374
2
votes
4 answers

Class Constructor and Get Design

When designing a class and the constructors I have a question regarding getting a record. In an example if I have a car class public Car { ... } I have the option of creating a constructor that could get a certain instance of a car for…
TreK
  • 1,144
  • 2
  • 13
  • 25
2
votes
1 answer

Usage / handling of non relational datasources in .NET applications

Which .NET (data / middel-tier) technologies / framworks can / should be be used, if the datasource isn't a classical relational database, but a service or a remote function call or whatever ? Are technologies like WCF RIA services or WCF DATA…
uhu
  • 1,702
  • 5
  • 17
  • 26
2
votes
2 answers

Provide different data access interfaces from a central class: is there a pattern I could/should use?

I want to begin rewriting (step by step) a data access layer in an old application. We use the Entity Framework as object relational mapper, so the "pure data access" is already done. What still needs to be done is providing the "next" layer (I call…
InvisiblePanda
  • 1,589
  • 2
  • 16
  • 39
2
votes
2 answers

Creating base class for Entities in Entity Framework

I would like to create a base class that is somewhat generic for all of my entities. The class would have methods like Save(), Delete(), GetByID() and some other basic functionality and properties. I have more experience with Linq to SQL and was…
Thomas
  • 1,177
  • 1
  • 14
  • 26
2
votes
1 answer

Will I use stored procedures or direct write code in a mvc web project?Which is better?

My web project is using telerik dataaccess ORM,when I deal with the data,I can use stored procedures or direct write code.I find it is more efficient to use stored procedures.But some of my workmate say that using stored procedures is difficult to…
Lyly
  • 718
  • 1
  • 8
  • 17
2
votes
2 answers

Visual Studio 2010 ADO.NET Data Model vs Linq to SQL

What's the difference between the two? They seem to have the same functionality at first glance. Which one has faster performance which one is easier to use?
LaGrad
  • 107
  • 5
2
votes
1 answer

.NET Entity Framework "remembering" database name that does not exist

I'm using Brock Allen's awesome MembershipReboot library to provide identity services in my .NET application. Per Getting Started with MembershipReboot, MembershipReboot uses Entity Framework (EF) for it's data access. The sample apps contain a SQL…
Matthew
  • 947
  • 2
  • 13
  • 20
2
votes
1 answer

Best Data Access Model for WinForms applications

Which data-access model has the best performance and speed for a C# Winforms application? Dataset? NHibernate? Entity Framework? Why would people say not to use Datasets ?
Hossein Moradinia
  • 6,116
  • 14
  • 59
  • 85
2
votes
2 answers

Why is queried data returned in a result set and not in an array?

Why do most programming languages use the concept of result set when returning data from a database? Why aren't the results returned directly in a more common, immediately usable structure like an array? Why is this extra layer between querying and…
marcv
  • 1,874
  • 4
  • 24
  • 45
1 2 3
…
21 22