Questions tagged [daab]

51 questions
0
votes
1 answer

Configuring the Enterprise Library DAAB for use in a SharePoint timer job

I am trying to set up a timer job which uses the Enterprise Library DAAB. The DAAB is working fine in the conext of the the front end servers (aspx page), where the data connection is retrieved from the web.config. But in the context of a timer job,…
0
votes
1 answer

Data Access Application Block 4.1 and Transactions

Can anyone please tell me what is the prefered way to manage transaction when using Enterprise Library's DAAB (version 4.1)? I was thinking about Database NewDb = DatabaseFactory.CreateDatabase(); DBCommand NewCmd =…
B.M
  • 533
  • 2
  • 8
  • 16
0
votes
1 answer

Data Access Application Block 5.0 fluent configuration

I am using following code to setup connection string: ConfigurationSourceBuilder builder = new ConfigurationSourceBuilder (); builder.ConfigureData () .ForDatabaseNamed ( "TestDatabase" ) …
Munawar
  • 2,588
  • 2
  • 26
  • 29
0
votes
1 answer

Using "LINQ to SQL" and "WCF Data Services" on top of Data Access Application Block

In my application, the entity database schema is created after application deployment based on inputs captured from end user, using a tool. I cannot use Entity Framework in this situation, since modeling is not possible without development…
0
votes
1 answer

Enterprise library 5 login failed for user

I've just started to use the enterprise library 5 data access application block, but I keep on getting login failed errors. I've tried the connection string that I'm using without the application block and the connection opens fine, but as soon as I…
Martin
  • 587
  • 1
  • 6
  • 18
0
votes
2 answers

How to Populate a dropdown using Enterprise Library 5.0

Is there a simple code to populate a dropdown box using Enterprise Library 5.0 DAAB? I've tried this, but it is not working: cmbOffice.DataSource = _db.ExecuteDataSet( CommandType.Text, "select office_id, office_name from…
0
votes
3 answers

getting multiple sets of data in one request?

I am working on a site in which as user logs in (first database request) the stored procedure varify password and user id and then returns user record that I put in session to use next. After this I do a second db request. it returns addresses of…
haansi
  • 5,470
  • 21
  • 63
  • 91
0
votes
1 answer

EntLib 6 and ODP.NET - Accessor loses parameters

I'm sure I can't be the first one trying to use EntLib 6's Accessors to execute an Oracle SP with parameters. It all worked fine and dandy when I was using the (deprecated) OracleClient from MS, but when I switched to Oracle's own ODP.NET (using…
0
votes
1 answer

Mapping Application Blocks in Enterprise Library 5.0 (Data Access Application Block)?

I have been dabbling at Enterprise Library 5 Data Access blocks and it is pretty neat that you can return objects using IRowMapper (with and without creating accessors) http://msdn.microsoft.com/en-us/library/ff664533%28v=PandP.50%29.aspx I have…
ram
  • 11,468
  • 16
  • 63
  • 89
0
votes
1 answer

Disposing of custom Data Access Layer references

Our application uses a custom DataAccessLayer class almost exclusively, and within that we do use Data Access Application Block (currently version 2). We are getting the infamous "GetOrdinal" error sporadically. We are not using out-of-method…
Mike
  • 417
  • 7
  • 28
0
votes
1 answer

Calling MS Access Stored Queries with Parameters using DAAB v5.0

I wanted to find out if it is possible to call MS Access Stored Queries with parameters using DAAB. I am using the Northwind sample database to test this scenario I have created the following Stored Query with parameter in MS Access: PARAMETERS…
Manthan
  • 393
  • 2
  • 5
  • 13
0
votes
1 answer

Is the MS DAAB 4.1 Database object threadsafe?

I've come across some code that has a singleton which creates / reuses a static instance of the MSDAAB Database object. Is the Database object threadsafe after creation? I couldn't find anything one way or the other in the MSDAAB docs.
Daniel Auger
  • 12,535
  • 5
  • 52
  • 73
0
votes
1 answer

How to know the exact statement fired in Data app block?

We are using "Enterprise Library Data Access Application Block" to access SQL Server database. In DataAccess layer, we are calling application block's API. Internally it must be resolving the command and parameters into SQL statement. How can I know…
AJ.
  • 345
  • 5
  • 19
0
votes
1 answer

Is a base class with shared fields and functions good design

I've got a BaseDataClass with shared fields and functions Protected Shared dbase as SqlDatabase Protected Shared dbCommand as DBCommand ... //also have a sync object used by the derived classes for Synclock'ing Protected Shared…
eych
  • 1,262
  • 2
  • 16
  • 37
0
votes
1 answer

Using DAAB to update a DataTable without a DataSet

Currently, there is only UpdateDataSet function that takes a dataset param. If there is only a datatable to update, with no dataset associated, do I need to create a dataset just to pass it in? Any way to update just a table?
eych
  • 1,262
  • 2
  • 16
  • 37