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
0 answers

Filtering nested lists

This is a follow-up of this question, as I have trouble extracting the data that I need using the Filter and lapply functions. Let's say I have the following data (which is of course only an excerpt): result <- list( list( startSize = 2,…
Markstar
  • 639
  • 9
  • 24
2
votes
3 answers

Which Data Access layer is the recommended today for ASP.net?

I'm currently building a small website where I write down problems that arise and answers to them for others to see. Currently I'm using a DAL much like the one described here. Now I have been looking at other models, and in particular linq based…
miccet
  • 1,870
  • 3
  • 19
  • 26
2
votes
3 answers

Help! Flash cannot load XML data from a third-party domain

I am getting news from Yahoo using an RSS feed, using: XML.load("http://finance.yahoo.com/rss/topstories") Yea this is legal and all, and although it works perfectly when my SWF is offline -- it shows a security error, but I allow my D drive…
Robin Rodricks
  • 110,798
  • 141
  • 398
  • 607
2
votes
4 answers

How can I access a MATLAB (interpolated) spline from another program?

If I was to create interpolated splines from a large amount of data (about 400 charts, 500,000 values each), how could I then access the coordinates of those splines from another software quickly and efficiently? Initially I intended to run a…
Mike Furlender
  • 3,869
  • 5
  • 47
  • 75
2
votes
2 answers

How to return individual columns from EF queries while using repository pattern

My app’s data access layer is comprised of entity framework and the repository pattern*. Using entity framework logging I’ve discovered a handful of queries which are bringing back all columns of an entity (of course it’s obvious that was the case…
Howiecamp
  • 2,981
  • 6
  • 38
  • 59
2
votes
1 answer

InvalidOperationException when try to ExecuteReader() with Oracle Data Access ODP.NET 11.2

It's the first time I HAVE to work with Oracle, and as we all hate to work with foreign stuff while you are working with a specific model some years, although this is our job and we have to make it. Now i have installed the Oracle 11 g and copied…
George Taskos
  • 8,324
  • 18
  • 82
  • 147
2
votes
0 answers

.Net core 2.1 and channel encryption

I had an .Net Core 2.1 application (with Visual Studio 2017 / SQL Server 2016). I am in the security phase. I search a solution to respect the GDPR norm. TDE (Transparent Data Encryption) was chosen to encrypt the database (AlwaysEncrypted was not…
Mel dev
  • 21
  • 2
2
votes
1 answer

How should we use ASP.NET Data Access Classes (Converting from ColdFusion)

We're converting from ColdFusion to ASP.NET 4.0 and we just don't know which route to take with setting up our classes. In college I was taught to break everything up into separate Data Access Classes and Entity Classes that speak to the DAC. To me,…
Michael Stone
  • 950
  • 2
  • 14
  • 30
2
votes
1 answer

What is the Best Way to Perform Geo Spatial Searches with Entity Framework Code First CTP 5?

I'd really like to give Entity Framework 4 Code First CTP a try with a greenfield app but I want to make sure that geo spatial searches will not be a problem before I do, or I'll go another route. Has anyone performed a geo-spatial search with EF…
Chance
  • 11,043
  • 8
  • 61
  • 84
2
votes
2 answers

Silverlight: Best practices for accessing enterprise data

I am starting to put together a system architecture document for a new project at my company. Basically we have a rather large business layer that follows the enterprise library data pattern, and i will need to access these data objects from a new…
Jason Miesionczek
  • 14,268
  • 17
  • 76
  • 108
2
votes
2 answers

IS select top x reliable on large data sets in MSSQL

My question is to whether the following is reliable on a large dataset in MSSQL: select top 1 * from table order by row_id I was wondering if there was some threshold that when met will return the top 1 from a set of data. For example if there was…
Maxqueue
  • 2,194
  • 2
  • 23
  • 55
2
votes
2 answers

What is the most effecient way to pull thousands of records with hundreds of thousands of child records into class objects?

I have a scenario where I need to pull approximately 7500 database records where each records has 6 child entity lists. Each of those child lists could be 0 to approximately 125 records. My class structure kind of looks like this: public class…
Chris Conway
  • 16,269
  • 23
  • 96
  • 113
2
votes
6 answers

Efficient way to select default value in t-sql when no results are found

OK, this is a pretty simple problem, but I'm curious: what is the best approach in terms of efficiency and style? I often need to select data in MS SQL, but am looking for a single result. If there is no match in the database, I'd like to return a…
jkelley
  • 2,570
  • 3
  • 21
  • 24
2
votes
1 answer

Swift MVVM Example with Business & Data Layers

Most of the Swift MVVM examples I came across use Dependency Injection to inject Model into ViewModel, and then ViewModel into the ViewController. This injection is normally recommended to be handled in AppDelegate as its a singleton. Thats all fine…
AlexVPerl
  • 7,652
  • 8
  • 51
  • 83
2
votes
2 answers

what is the difference between data access layer and data access object?

I am new to this concepts data access layer and data access objects. I wants to the difference between the data access layer and data access object.Please guide me.
Muneeswaran Balasubramanian
  • 3,839
  • 8
  • 31
  • 43
1 2 3
…
21 22