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
4
votes
2 answers

Recommended programming pattern for multiple lookups

I've been tasked with creating a data synchronization process between a CSV file generated by another vendor and upwards of 300 separate-but-structurally-identical CRM databases. All CRM databases are defined in the same SQL Server instance. Here…
Jake Bullet
  • 455
  • 1
  • 4
  • 9
4
votes
6 answers

How do I create a generic overall .NET programming structure for my company?

I'm in a company that writes their own business data applications when there's no good off the shelf alternative. Most often it's - a login screen - some screens that are mostly visualizations of SQL Server tables - some reports In the past…
user285941
4
votes
8 answers

Where to put restrictions on entities when separating Business layer from Data Layer

I am attempting to create the the business and data layers for my big ASP.NET MVC application. As this is the first time for me attempting a project of this scale I am reading some books and trying to take good care at separating things out…
KallDrexx
  • 27,229
  • 33
  • 143
  • 254
4
votes
3 answers

Data access, unit testing, dependency injection

I've recently got a task to create a simple utility that allows to import data from a file with special format to the database. I've implemented console application with few classes(Program class operates with business logic class, business logic…
Dev
  • 367
  • 1
  • 10
4
votes
9 answers

Java: Advice on handling large data volumes. (Part Deux)

Alright. So I have a very large amount of binary data (let's say, 10GB) distributed over a bunch of files (let's say, 5000) of varying lengths. I am writing a Java application to process this data, and I wish to institute a good design for the data…
Jake
  • 15,007
  • 22
  • 70
  • 86
4
votes
1 answer

Helping to Understand Web Services and REST

I've been longing to ask this question, but only found the time to do so now. Anyways, there has been much of a discussion on Web Services (yeah, those traditional SOAP-XML response services) and RESTful services (which a lot of devs are into right…
Angelo
  • 1,578
  • 3
  • 20
  • 39
4
votes
7 answers

Why switch from ADO to ADO.NET?

I have some friends who are 'old-school' VB6 database developers and I was telling them about .NET and its features, specifically ADO.NET. In our conversation, they brought up the following reasons why they would rather stick with ADO than move to…
Anirudh Goel
  • 4,571
  • 19
  • 79
  • 109
4
votes
1 answer

Using of System.Security.Permissions.DataProtectionPermissionAttribute

Have you ever used this class in real world application? Can you imagine scenarios where it can be useful? I'm asking because in WCF there is MessageBodyMemberAttribute to control data integrity/encryption and wonder if they're somehow related.
UserControl
  • 14,766
  • 20
  • 100
  • 187
3
votes
2 answers

What should I be using with ASP.Net MVC, NHibernate, LINQ, EF?

Hi I posted a question a little earlier and I had some replies that I should look at some different technologies. Which of the above (or other feel free to mention) is the most popular or best supported. As stated in my earlier question I am…
uriDium
  • 13,110
  • 20
  • 78
  • 138
3
votes
1 answer

How should I handle creation of composite entities with a hand-rolled DAL?

For reasons beyond my control I cannot use a real ORM, so I am forced to create a custom DAL that sits over the raw data and returns "domain objects" to the consumer. Also for reasons beyond my control I must use Stored Procedures for data…
Wayne Molina
  • 19,158
  • 26
  • 98
  • 163
3
votes
4 answers

Data mapping code or reflection code?

Getting data from a database table to an object in code has always seemed like mundane code. There are two ways I have found to do it: have a code generator that reads a database table and creates the class and controller to map the datafields…
Josh
  • 10,352
  • 12
  • 58
  • 109
3
votes
2 answers

How to programmatically access Orchard CMS content from outside?

To be specific, I'm going to use Orchard CMS as a back-end for content editors for an existing website. My website is too complicated to wrap it into an Orchard custom Module, so I decided to use stand-alone instance of Orchard as backend, and query…
AndreyTS
  • 232
  • 2
  • 13
3
votes
4 answers

Swapping out databases?

It seems like the goal of a lot of ORM tools and custom data access layers (DAO pattern, etc.) is to abstract the database to the point where you could supposedly swap out the entire database system with minimal work. Following the common DAL…
Andy White
  • 86,444
  • 48
  • 176
  • 211
3
votes
1 answer

How to ensure that MonoBehaviour object has loaded its data before another Actor wants to access it?

I have an Inventory : MonoBehaviour that loads some mock data in Start(), including a "selectedWeapon" variable that is set and can be read. Let's say I want to access this variable when I set up another MonoBehaviour in the same scene. Is there a…
OG NEO
  • 33
  • 3
3
votes
2 answers

Fast SQL question about multiple month dates

SELECT DISTINCT MonthName(Month([Date])) AS [Month], tblSupportCalls.System, Count(tblSupportCalls.System) AS [Total for System], Year([Date]) AS [Year] FROM tblSupportCalls WHERE (((tblSupportCalls.Date) Between Now() And Now()-7) AND…
Alex
  • 174
  • 1
  • 3
  • 14
1 2 3
…
21 22