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
0
votes
1 answer

Visual Basic 6 tutorials for data access and CRUD

Do you know some tutorials (preferably a website or a blog) in Visual Basic 6 (not Visual Basic .NET) for data access or CRUD? The caliber and depth that I'm looking for is similar to this site: Data Access Tutorials for…
yoitsfrancis
  • 4,278
  • 14
  • 44
  • 73
0
votes
3 answers

SQL Compact allow only one WCF Client

I write a little Chat Application. To save some infos like Username and Password I store the Data in an SQL-Compact 3.5 SP1 Database. Everything working fine, but If another (the same .exe on the same machine) Client want to access the Service. It…
Summer-Time
  • 1,824
  • 15
  • 19
0
votes
5 answers

ORM vs parametrized queries if my only concern is speed of data access

I work in an ASP.net/ SQL Server development environment. If my only concern is speed should I go with parametrized queries or should I use an ORM such as nHibernate or LINQ?
jim
  • 26,598
  • 13
  • 51
  • 66
0
votes
1 answer

Service locator - a 'secure' way to identify a service has registered or not

I'm working on a Service locator system where services could register and get requested around the codebase. The whole code if you're interested. The problem that I'm having, I'm trying to make it so that if a service instance has already…
vexe
  • 5,433
  • 12
  • 52
  • 81
0
votes
3 answers

How do I access data from my personal computer on my AMI instance running RStudio server

I have recently set up RStudio on an AMI ec2 instance using the process generously laid out by Louis Aslet from his website. But in an embarrassing turn of events I can't access the data I need because it resides on my personal computer. I am new…
mLudwig
  • 21
  • 2
0
votes
1 answer

Azure Mobile Services - Data Access - Developing for both mobile apps and websites

I'm developing with Azure Mobile Services (using SQL Azure) to provide a backend for both IOS and Android mobile apps and a PHP website. My question is now that now custom apis have been introduced is it considered best practice to wrap everything…
0
votes
3 answers

Read Input Text File and Compare (Android)

I have this text file named params.txt which consist of: 3 WENSY WENDY PING PING CHLOE CHLOE My question is, how can I read this inputs and compare the two strings in one line? Compare Wensy and Wendy and so on.. Code: public class MainActivity…
pingboo23
  • 137
  • 1
  • 3
  • 15
0
votes
2 answers

Data Access Design: Multiple result set single stored proc or single result set per stored proc

Which is a better approach to building a complex object (eager loading). A single call to a stored procedure that returns multiple result sets or multiple calls to stored procedures with one result set each? I'm building my DAL using T4/text…
rro
  • 619
  • 5
  • 22
0
votes
1 answer

making a universal db_access file

Working on a project where i am using wamp and phpmyadmin to make a website. I am doing a little bit of databasing. I would like to have a file that would could work on both my local database as well as my live database. exp. Local…
Sari Rahal
  • 1,897
  • 2
  • 32
  • 53
0
votes
1 answer

Loading large amount of text files from a share drive to search for a world. C#

Im trying to perform a search in a share drive that contains at least 90,000 files. The code below is what I have: private void button2_Click(object sender, EventArgs e) { if (string.IsNullOrEmpty(textBox1.Text)) { …
0
votes
2 answers

Server control/data access best practice?

Is it better to access data from within the web parent app and pass the necessary data to the control and back via properties, or pass a reference or url pointer (of webservice) to control and let it access the data for the fields it encompasses…
suedeuno
  • 395
  • 1
  • 4
  • 12
0
votes
1 answer

Spring & JSP: Accessing variables members through associations

I'm trying to display data in a JSP file and I got a question about how deep I can access my data's members (god this sounds wrong). So I have an entity called Assignment which holds OneToOne relations to other entities such as Project and Role. For…
Michael De Keyser
  • 787
  • 1
  • 17
  • 45
0
votes
2 answers

Relational object mapping c#

What is the best way to map relational table which has more than 150 columns. I don't want to use any 3rd party or entity framework. if i am using data-reader it is very hard to write all the columns and convert it to relevant type. Is…
FatalError
  • 77
  • 2
  • 9
0
votes
3 answers

ORM Mapping software replacement

We have a large web application that uses multiple databases (all currently MS SQL Server 2008 R2). This application is around 7 years old and was built around the EntitySpaces framework. It's currently using version 2009 of this framework, written…
0
votes
2 answers

.NET and Oracle.DataAccess.Client, what date format should I send?

I'm trying to insert a date from .net to an Oracle 10g database. I'm sending the date on this format dd-MM-yyyy, but I get an error message which says "Invalid month", if I try to send the format dd-MMM-yyyy (I've tried this because when I do Ctype…
amarruffo
  • 418
  • 2
  • 5
  • 15