Questions tagged [daab]

51 questions
1
vote
3 answers

Retrieving SQL Server database schema and objects and reflect in a .Net application

What is the simplest way to reflect the SQL Server database schema with all its objects in a .Net application? Basically I would like my application to scan the database schema and present me all tables and other objects. Further I should be able to…
Kabeer
  • 4,138
  • 7
  • 40
  • 62
1
vote
1 answer

Can we use dbCommand and AddInParameter while inserting always encrypted columns

Is there any way we can use dbCommand and AddInParameter while inserting always encrypted columns into table through .net? db.AddInParameter(dbCommand, "@SSN", DbType.string, SSN);
Windows10
  • 51
  • 9
1
vote
2 answers

Hybrid NHibernate DAL/BLL

I have an existing asp.net webforms project that uses Microsoft's Enterprise DAAB for the DAL, I need to implement some extensive features, and I would like to use NHibernate to make things easier. Is there any design patterns/architectures out…
Element
  • 3,981
  • 7
  • 42
  • 51
1
vote
2 answers

The data source is of an invalid type. It must be an IListSource, IEnumerable or IDataSource

I'm upgrading a .NET 2.0 site that uses Enterprise Library version 2 (DAAB mainly) to .NET version 3.5 and EntLib version 5. I've made the necessary changes and now I'm getting an error "The data source is of an invalid type. It must be an…
Mike
  • 417
  • 7
  • 28
1
vote
1 answer

DAL classes generater using DAAB or ado.net?

I am using enterprise library DAAB with 4 layers User interface layer, custom type layer, business logic layer, data access layer. I want to remain in 4 layers please guide is there any preferably free/ open source code generater that can generate…
haansi
  • 5,470
  • 21
  • 63
  • 91
1
vote
1 answer

Is the Microsoft Enterprise Library Data Access Application Block thread safe?

I can't seem to find any documentation regarding thread safety... In particular - is the Database class (and subclasses) thread safe How would I find this out for myself? Are there references to thread safety for classes on the MSDN site?
Ed Vowles
  • 67
  • 5
1
vote
3 answers

Get Autonumber from newly inserted record in Access 2007 using Enterprise Library 4.1

It's been ages since I last used Access as a back end but I'm being forced to. I'm using Enterprise Library 4.1, the Data Access Application Block.. with .NET 3.5 and I wanted to know the best way (code sample if possible) to write an insert query…
GR7
  • 5,083
  • 8
  • 48
  • 66
1
vote
2 answers

C#: Is this the correct way to use the SqlDataReader for DAAB

I have just started using the Data Access Application Block from microsoft. There are very few instructions on the correct way to use the library. Just wanted to know if this is the correct way to use the data reader. SqlDataReader reader =…
Luke101
  • 63,072
  • 85
  • 231
  • 359
1
vote
2 answers

Returning ref cursor from oracle stored procedure by using DAAB from MS EntLib 4.1

Is it possible to get ref cursor from oracle stored procedure by using DAAB from Microsoft Enterprise Library 4.1?
afin
  • 546
  • 3
  • 11
  • 21
1
vote
2 answers

ODP.NET in Microsoft Enterprise Library 6.0

There are a couple of questions floating around about this, but none have been really answered. Basically - is there currently an implementation of ODP.NET for enlib (6.0) currently being used? Or will I have to go down the route of writing a…
djangoat
  • 475
  • 4
  • 12
1
vote
1 answer

.NET TransactionScope on Oracle

we are using DAAB and TransactionScope on Oracle. Our application manage all the connection to only 1 database. This type of implementation it seems to need "Oramts.dll". Is there a way of using your DAAB and TrasnsactionScope without MTS? Thanks!
Babba
  • 253
  • 1
  • 5
  • 12
0
votes
2 answers

Run-time Error on deployed project using DAAB 4.1

I'm having a weird problem on deployment while trying to use Microsoft Enterprise Library's Data Access Application Block 4.1. I get the following Unhandled Exception when trying to use the element of the web application that utilizes the…
smathson
  • 108
  • 2
  • 6
0
votes
3 answers

Microsoft Enterprise DAAB and Closing Connections

I noticed one of our internal apps was using DAAB, and that it appears to have some sort of connection leak. I thought I remember reading somewhere that when you used the following code: Database db =…
Nick
  • 1,708
  • 14
  • 18
0
votes
1 answer

Handling a dynamic Connection String with DAAB

I'm in the process of adding a Data Access Layer for our ASP.Net 2.0 web application that was written almost exclusively using in-line SQL calls and copious use of copy/paste. Due to business concerns I am only able to re-factor small portions of…
smathson
  • 108
  • 2
  • 6
0
votes
1 answer

How to batch insert lots of rows using Enterprise Library DAAB?

How can I execute 1000s of INSERT queries using Enterprise Library DAAB? That is to say how can I insert lots of rows into a table using DAAB all at once efficiently? And without using a for-loop. Thanks.
Kayes
  • 1,016
  • 3
  • 15
  • 22