Stack Overflow
Stack Overflow

Questions tagged [daab]

51 questions
13
votes
6 answers

Problem when trying to configure enterprise library 5.0 (Data Access Application Block)

I am running into some problems while trying to get DAAB from Enterprise library 5.0 running. I have followed the steps as per the tutorial, but am getting errors... 1) Download / install enterprise library 2) Add references to the blocks I need…
Phil
  • 1,811
  • 9
  • 38
  • 60
6
votes
4 answers

How to Convert Datareader Result of DbType.Time to Timespan Object?

I am reading a result from a MS SQL 2008 Database with a column type of dbtype.time from a datareader, using c# with DAAB 4.0 framework. My problem is the MSDN docs say dbtype.time should map to a timespan but the only close constructor for timespan…
Element
  • 3,981
  • 7
  • 42
  • 51
6
votes
6 answers

Cast error on SQLDataReader

My site is using enterprise library v 5.0. Mainly the DAAB. Some functions such as executescalar, executedataset are working as expected. The problems appear when I start to use Readers I have this function in my includes class: Public Function…
Phil
  • 1,811
  • 9
  • 38
  • 60
5
votes
1 answer

Are some Enterprise Library Application Blocks becoming obsolete?

With the introduction of newer paradigms in ASP.Net, are some of the Application Blocks in Enterprise Library becoming obsolete? For example, look at following: ASP.Net Membership, Role & Profile provider as opposed to Security Application…
Kabeer
  • 4,138
  • 7
  • 40
  • 62
4
votes
2 answers

The number of parameters does not match number of values for stored procedure

I am using Enterprise Library 5x DAAB to call an Oracle stored procedure with one input parameter and one output parameter. But it gives this error: The number of parameters does not match number of values for stored procedure My code is…
Kayes
  • 1,016
  • 3
  • 15
  • 22
4
votes
1 answer

DAAB, the best approach to use Database instances is

Guys, I am going to use Enterprise Library (4.1) and especially DAAB. Here is I have questions: What is the best approach and why: Every time when I need to run a DbCommand I create Database instance using DatabaseFactory.CreateDatabase(); I have…
Antipod
  • 1,593
  • 3
  • 23
  • 43
3
votes
1 answer

Dynamic connection string in DAAB

I am having a situation where i need multiple connection strings to process a request, but i am not able to implement this using the Microsoft enterprise library. somebody please tell me how can i set the connection string dynamically. found similar…
Bravo
  • 3,341
  • 4
  • 28
  • 43
3
votes
1 answer

Why is a call to DatabaseInstance.ExecuteSprocAccessor(...) taking so long for such a simple query?

Very odd slowdown when calling the Data Access Application block. The SP ("QuestionsToBeAnswered") it's calling returns 58 rows with three columns (two GUIDs and an integer: 21AF77DA-2E76-47DB-AB54-0E5C85CD9AD8, 21AF77DA-2E76-47DB-AB54-0E5C85CD9AF0,…
David Waldock
  • 31
  • 2
2
votes
1 answer

Inject DAAB Database Object with Unity

I'm trying to create a DAO object that takes a constructor dependency to the Data Access Application Block's Database object. How do I setup my .config file to have Unity resolve the dependency? I've tried mapping the Database type to create a…
Tuan
  • 5,382
  • 1
  • 22
  • 17
2
votes
4 answers

Lightweight ADO.NET Helper Class

Can anyone point me towards a current library that provides basic wrapping of ADO.NET functionality? I'm looking for something along the lines of the old SqlHelper class and am not really interested in using the Data Access Application Block (as…
DanP
  • 6,310
  • 4
  • 40
  • 68
2
votes
2 answers

Data Access Application Block (DAAB) and the SQL IN keyword (multiple criteria)

I am using the Patterns and Practices Data Access Application Block and I want to be able to perform a SELECT using multiple criteria like you can do in SQL using the IN keyword. Such as: SELECT * FROM SomeTable WHERE PrimaryKey IN (@keys) How can…
Keith
  • 2,563
  • 1
  • 17
  • 9
1
vote
1 answer

Enterprise Library 5.0 - DatabaseFactory.CreateDatabase() - Slow performance

Im using Enterprise Library 5.0 Data Access block. the Creation of a databaseinstance is really slow. DatabaseFactory.CreateDatabase() statement consumes a lot of time when connecting to SQL Server What are the best practices for high performance…
Sundararajan S
  • 1,358
  • 2
  • 14
  • 24
1
vote
2 answers

DAAB and ref cursors, Why no up to date tutorials?

Why are there no up to date tutorials books, or anything like that online for working with enterprise library 5.0 and Oracle ref cursors? Is there no one on Earth who needs help with that? I am absolutely dumbfounded. There was a way to do it in…
SoftwareSavant
  • 9,467
  • 27
  • 121
  • 195
1
vote
1 answer

DAAB, do we need to handle connection opening closing manually?

I am using DAAB. Plz guide me do we need to check and clsoe connections manually after a db call ? thanks
user576510
  • 5,777
  • 20
  • 81
  • 144
1
vote
1 answer

DAL design using DAAB 3.5/4.0

I'm working on a .Net 3.5 web application.It has various modules say for example Customers,Orders,etc.... I need to a design Data Access Layer (DAL) for the same using Enterprise Library 4.0 (using Data Access Application block or DAAB) to connect…
Jeremy Thomson
  • 999
  • 3
  • 16
  • 17
1
2 3 4