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

What's the point of ORM If I have to define every field in app.config for Oracle .net Entity Framework

To my knowledge, the whole point of Entity framework is to simplify and unify data access models. I downloaded latest Oracle's .net tools (ODAC 11.2 Release 4) which claims EF4 support, and I'm trying to import some Oracle stored procedure (through…
Bassel Alkhateeb
  • 1,584
  • 5
  • 19
  • 35
4
votes
2 answers

Spring mvc:resources access to outside folder

I have stored medias (pictures and movies) in a folder (for example C:\test\tes.png) and I'm trying to access to pictures with an url like : http://localhost:8080/app/picture/test.png. To do that, i have used resources tag (spring 3) as below…
user1034407
  • 43
  • 1
  • 3
4
votes
1 answer

LINQtoSQL and Serialization

I am a newbie to LINQtoSQL. I opted to learn it because I didn't have much experience writing stored Procedures in SQL and thought that LINQtoSQL might be an alternative way to do data access. Anyway, I created a simple ASP.NET application with a…
Fike Rehman
  • 725
  • 2
  • 7
  • 16
4
votes
2 answers

How to correctly deploy Oracle.DataAccess.dll with ASP.NET app

We had some x64 / x86 trouble when we first deployed the Oracle.DataAccess.dll with our app on different servers with 64/32 bit Windows. Now that we figured out how we can get the app to reference the correct version, I still have trouble with a…
Niels Ziegler
  • 466
  • 2
  • 6
  • 15
4
votes
1 answer

How to bundle oracle data access dll?

I use Oracle.DataAccess.dll for Oracle Version 10.2. with .NET. I give the compiled application to the customer and it doesn't work for him because I am guessing ODP.NET is not on his machine. I asked him to download and install it from Oracle,…
Haoest
  • 13,610
  • 29
  • 89
  • 105
4
votes
3 answers

Inserting values to a table using generic dictionary

Coding Platform: ASP.NET 2.0 WebForms with C# with MySQL as backend Background I am currently working on a bug fixing a website. One of the table "registrations" have 80 columns. The Insert/ Update is done through simple sql statements without any…
naveen
  • 53,448
  • 46
  • 161
  • 251
4
votes
5 answers

Programmatically accessing Data in an ASP.NET 2.0 Repeater

This is an ASP.Net 2.0 web app. The Item template looks like this, for reference: <%#…
peacedog
  • 1,415
  • 20
  • 32
4
votes
6 answers

Using interfaces for writing DAO classes

I'm creating a new web application which will use a bunch of Data Access Object(DAO) classes for doing CRUD operations on the data. I know I should write java interfaces when I have external users/applications using my DAO classes. But if there is…
Srini Kandula
  • 981
  • 2
  • 18
  • 47
4
votes
3 answers

When should I use a SQLTransaction

What is the appropriate time to use a SQLTransaction? I use them for all of my INSERT, UPDATE and DELETE statements. Is this the correct usage or am I doing a bit of overkill?
Popeye
  • 43
  • 3
4
votes
4 answers

ORMs for WebServices DataSources?

There seems to be lots of great Object Relational Mappers out there - several of which I have used myself (LLBLGen being one I like a lot). Does anyone know of any .Net tools out there to help build a rich Data Access layer when the DataSource is…
James
  • 7,877
  • 7
  • 42
  • 57
4
votes
1 answer

Oracle.DataAccess.Dll x64 support

My oracle.dataaccess.dll is not supported on x64 machines. I've looked for it everywhere - but all I could find is the x86 version. Anyone knows where can I get it from?
Nissim
  • 6,395
  • 5
  • 49
  • 74
4
votes
3 answers

Is this a bug with PHP array accessing?

I ran into this bug where an element of an array, if its index is the string "0", is inaccessible. It's not a bug with unserialize, either, as this occurred in my code without invoking it. $arr =…
John
4
votes
0 answers

Neon on Android limited by memory access?

I have programmed a routine to process single float arrays using Neon on the Android platform, specifically the Samsung S4, and find that my Neon routines are limited by the access to the array data. For interests sake, snippet below: Neon m1 = …
magicfoot
  • 41
  • 1
4
votes
1 answer

Error when connecting to AS400 (ISeries)

I'm trying to connect to a AS400 server using the .net classes. I have added a reference to IBM.Data.DB.iSeries and I use the following code: var conn = new iDB2Connection("DataSource=111.111.111.111;UserID=xxx;Password=xxx;…
Jimmy Engtröm
  • 1,998
  • 4
  • 23
  • 34
4
votes
6 answers

How important is it for me to pool my connections?

It has been suggested to me that I rearrange my code to "pool" my ADO connections. On each web page I would open one connection and keep using the same open connection. But someone else told me that was important 10 years ago but is not so…
Rio Mango
  • 43
  • 5
1 2 3
…
21 22