Top "Data-access" questions

Data access typically refers to software and activities related to storing, retrieving, or acting on data housed in a database or other repository.

Saving multiple objects in a single call in rails

I have a method in rails that is doing something like this: a = Foo.new("bar") a.save b = Foo.…

ruby-on-rails activerecord data-access
Can I have an optional OUTPUT parameter in a stored procedure?

I have a stored procedure that has a bunch of input and output parameters because it is Inserting values to …

sql-server stored-procedures data-access
How can I generate database tables from C# classes?

Does anyone know a way to auto-generate database tables for a given class? I'm not looking for an entire persistence …

c# code-generation data-access
Execute multiple SQL commands in one round trip

I am building an application and I want to batch multiple queries into a single round-trip to the database. For …

c# .net sql-server ado.net data-access
Should I use public or private variables?

I am doing a large project for the first time. I have lots of classes and some of them have …

c++ oop abstraction getter-setter data-access
How to fix "The provider is not compatible with the version of Oracle client"?

We're using the Oracle.DataAccess.dll assembly version 2.102.2.20 (32 bit). I deployed our Web API application to IIS and tried openning …

c# asp.net oracle data-access oracle-client
pooled connection timed out

On the production server sometimes randomly the connection fails to the ORacle database. I get a lot of Oracle.DataAccess.…

database oracle connection data-access
Opening .gdb database files

I'm trying to open an old interbase .gdb file. This is a new step for me and i don't know …

data-access interbase data-extraction
Best way to get a single value from a DataTable?

I have a number of static classes that contain tables like this: using System; using System.Data; using System.Globalization; …

c# .net datatable data-access