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

How to insert an n:m-relationship with technical primary keys generated by a sequence?

Let's say I have two tables with several fields and in every table there is a primary key which is a technical id generated by a database sequence: table1 table2 ------------- ------------- field11 field21 field12 …
bl4ckb0l7
  • 3,839
  • 4
  • 28
  • 33
0
votes
1 answer

need elaborate info on IBM DB2 error tokens while getting DataAccessException via hibernate

I am using IBM DB2 and Hibernate in my java application. Whwnever I end up with a DataAccessException in my application I am getting a stacktrace like follows DataAccessException: {}com.ibm.websphere.ce.cm.DuplicateKeyException:…
gowthamvelusamy
  • 45
  • 7
0
votes
2 answers

Read connection string from app.config in my DataAccess library project for dbContext

I am working on a VS2012 solution that has got an ASP.NET MVC 4.0 project and multiple class libraries like my Managers, providers and DataAccess projects. My dbContext class is defined inside the DataAccess project. My aim is to restrict the…
Hari
  • 477
  • 1
  • 9
  • 20
0
votes
1 answer

Is there any other way in PHP to access the database, aside from SQL queries?

I'm new to PHP and passing SQL queries by string in the backend doesn't seem really safe and DRY. I was thinking perhaps there is another way. Maybe something similar to Entity Framework and LINQ in .NET. I know that there is PHPLinq but that…
Andrew
  • 13
  • 7
0
votes
1 answer

AngularJs data access Levels

I am trying to make a application in springMvc, velocity with html pages and angularJs for ticket booking. This is my first time to use angularJs. NavBar Home | Application Setting | Travel | Bulk Booking | Users | Profile | Announcements | Support…
Sanjay Kumar
  • 415
  • 4
  • 9
  • 19
0
votes
2 answers

remote data & query to OpenVMS RMS files

What options exist to query RMS files in OpenVMS? The context for the query/access would be for BI & reporting. Currently, a very old FOCUS (Infomation Builders, v. 6.9.8) is in use, and that only from within the native OpenVMS command line…
Odj fourth
  • 649
  • 1
  • 9
  • 16
0
votes
1 answer

Access modifiers - Property on business objects - getting and setting

I am using LINQ to SQL for the DataAccess layer. I have similar business objects to what is in the data access layer. I have got the dataprovider getting the message #23. On instantiation of the message, in the message constructor, it gets the…
Mike
  • 1,532
  • 3
  • 21
  • 45
0
votes
1 answer

Database access through collections

I have an 3 tiered application where I need to get database results and populated the UI. I have a MessagesCollection class that deals with messages. I load my user from the database. On the instantiation of a user (ie. new User()), a…
Mike
  • 1,532
  • 3
  • 21
  • 45
0
votes
1 answer

Fastest way to access data

I have a large text file, file1.txt(contains many numbers) and I need to access the data inside it would it faster to use an array of the numbers and use array indexing or use an object or whatever accesses the data the fastest. The file is like…
user3856543
0
votes
2 answers

Recommend .NET data access layer/middle tier

I'm currently creating an MVC application that will likely to expand to include a silverlight, wpf and possible windows phone all using the same data. So I've created a class library to keep all my objects in and I've created the MVC app. My…
lancscoder
  • 8,658
  • 8
  • 48
  • 68
0
votes
0 answers

Solution for "Could not load file or assembly 'Oracle.DataAccess, Version=4.121.1.0, Culture=neutral, PublicKeyToken=89b483f429c47342' " required

I am trying to connect my application to ORACLE 12c but while i run the application specific windows service, getting the below error. Earlier I had both 11g and 12c and the issue appeared. So, I removed both of them and installed fresh 12c. Checked…
user3346282
  • 53
  • 1
  • 2
  • 10
0
votes
2 answers

Cannot implicitly convert type 'System.Data.DataSet' to 'string' access Div in Server Side

I'm going to access my Div in Server side then I need to bind data to that div My Code:
Server Side code: public void GetLeftPanelData() { DataAccess da = new…
TechGuy
  • 4,298
  • 15
  • 56
  • 87
0
votes
1 answer

How firefox fetches correct data from Browser Cache

Once we open a link in a new tab in Firefox, the data corresponding to that web page(static or dynamic) gets stored in Browser Cache. Then, when we switches at that tab again, it extracts data of that page from Cache(not requesting from the server…
Parit Agarwal
  • 1
  • 2
0
votes
2 answers

Functions can not to return individual items of a record, is it? Any workaround?

Basic things as struct in C data types, exist in all popular languages, and is expected that functions, of these languages, also can return a struct... And, by an orthogonality principle, is expected you can access the returned struct…
Peter Krauss
  • 13,174
  • 24
  • 167
  • 304
0
votes
2 answers

Try with multiple catch behavior

Given code similar to this: Try Try 'Code that throws an OleDBException Catch dbEx as System.Data.OleDb.OleDbException Console.WriteLine("Inner Specific Exception handler.") Dim newEx As New System.Exception("Database…
Mike_OBrien
  • 1,395
  • 15
  • 34
1 2 3
…
21 22