Im experiencing some problems while attempting to read a connection string from an App.config file in my Data Access Layer.I added the App.Config to the DAL Class Library, and added my connection string to the connectionStrings section but when I try to read it from my DAL its Returing Nothing.
[Code]...
I am generally following this tutorial, the main differences being I'm using 2008 R2 Express and Windows Forms, he is using 2005 & ASP.NET Web Site:'m building a minimalist Windows Form project for learning purposes. So I'm using a 1-table database with 2 columns, ContactID & Name. I added a dataset file, 'ContactsDataSet.xsd' to my project and added a single minimalist table adapter with just a fill() & getdata() method.Then I added a DataGridView control and connected it to the ContactsDataSet to confirm it was working and that worked fine. I ran it and it filled up with data as expected. Everything up to this point was auto-generated code.
View 4 RepliesI am putting some heavy though into re-writing the data access layer in my software(If you could even call it that). This was really my first project that uses, and things were done in an improper manner. In my project all of the data that is being pulled is being stored in an arraylist. some of the data is converted from the arraylist into an typed object, before being put backinto an arraylist.Also, there is no central set of queries in the application.This means that some queries are copy and pasted, which I want to eliminate as well.This application has some custom objects that are very standard to the application, and some queries that are very standard to those objects.
View 5 RepliesI am implementing a Data Access Layer (DAL), which is basically a set of classes with (VB.NET) Shared functions to actually execute the database (CRUD) calls. I am trying to figure out the best place to place the calls to the DAL within the class hierarchy. Let me give an example.Suppose I have a class Customer, with only standard ID, Name, Address1, etc. properties and maybe an overridden ToString function or so. I also have a DAL class with Shared methods, such as:[code]Would this be "cleaner" OOP? Or is it acceptable practice to let the presentation call the Dal, passing the business objects like my previous example:[code]
View 3 RepliesOne of the time consuming factors of writing the DAL is adding and assigning paramters of teh stored procedure if ther are more than 10 parameters and must link more than 3 tables this process will take a horrible amount of time..
View 10 RepliesIm writing a data access layer for my application.There are several functions that need to return a list of items like Employee Name, and EmployeeID so it can be bound to a dropdownlist.What would be the proper datatype to return, a Dictionary?The lists only contain 2 columns, a name and id.
View 5 RepliesI am trying to prototype an application with a data layer on my computer at home using Visual Basic 2008 express edition with SQL Server Compact 3.5. My production situation at work is SQL Server 2000 and I am using Visual Basic 2005 professional for development.I am trying to write the code to create a seperate data layer. Here is my code. First the data layer:
Imports
System.Data
Imports[code].....
My Problem is that the data does not show up in the text boxes.
I typically dont create interfaces unless i have to, however in my current application i have to create interfaces in the Data access layer. I'm a in a minor confusion that hwo do i create those interfaces more how to implement them: the following code might make things clear:I have the following class and interface in the data access namespace
[code="vb"]Imports ConsoleApplication8.BusinessLayerImports ConsoleApplication8.DataAccessLayerImports System.DataImports System
Namespace DataAccessLayer
Public Class CountryGateway Implements ICountryGateway
[code]....
1. Is this way implement the interface in the data access layer? (in this case the class CountryGateway access the database.)
2. I have been told that we should create interfaces than abstract classes espcially in the data access layer, is there a particular reason for this?
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 connections. We are using DAAB version 2. Below is a typical example of our DAL methods:
Public Function MyDALMethod(ByVal Param1 As Integer, ByVal Param2 As Integer) As System.Data.IDataReader
Dim db As Database = DatabaseFactory.CreateDatabase()
[Code].....
My main question is should these DAL references be disposed somehow? It's a custom class written in VB.NET, so it doesn't implement IDisposable so I'm not sure if there's anything to be done or not, but we do have errors and issues (like the GetOrdinal problem) which seem to be load-related, and I'm wondering if this is part of the problem.
I'm creating my Data Access Layer and I want to return my object but not all the fields so this is the code i'm using
CODE:
I then call this method in the Business Logic Layer
CODE:
lastly I try to call in in my user interface and bind it to a DataGridView
CODE:
But I keep getting this error: Unable to cast object of type 'System.Data.Linq.DataQuery`1[VB$AnonymousType_0`3[System.String,System.String,System.String]]' to type 'System.Collections.Generic.IEnumerable`1[PP_DAL.DCProposal]'.
I would like to build a base class for my SQL Data Access Layer. I have most of it based out, but have a question about how to handle errors within the base class. I have a method for ExecuteNonQuery, ExecuteReader, ect...
[Code]...
IN my daat access layer, the stored procedure returns value of the format "CCT1". But i need to format that value to "CCT00001". Should i do this formatting in the data access layer or in the business layer?
View 4 RepliesI'm looking into adding some unit tests for some classes in my data access layer and I'm looking at an update routine that has no return value.It simply updates a row based on the id you provide at whichever column name you provide.Inside of this method, we collect the parameters and pass them to a helper routine which calls the stored procedure to update the table.Is there a recommended approach for how to do unit testing in such a scenario?
View 4 RepliesI am working in VB.NET defining my own classes. I have 5 classes, Policy, Coverage, CoverageCollection, Layer, and LayerCollection. Policy has a bunch of data items, one of which is of type CoverageCollection. Coverage has a bunch of data items, one of which is of type LayerCollection.
Policy
private id as Long
private name as String[code].....
Then I do like "dim p as Policy". So, iIn order to get to properties on a Layer, I reference it like p.cov(0).lyr(0).face. What I am trying to do is add a readonly property to Layer that is calculated using some Layer information but also using something from Coverage (or even Policy). I can take this in as a parameter to the property, but I think there should be a way to get at Coverage/Policy information since I am "under" it already. Is there a way to do this?
I am currently working on a vb project. What I am trying to do is reading a XML file and saving all the data in to the Access DB. Once this is done, I read the data from the access Db and display it in the required fields in VB form. Issue is, when i store the value in the access, a weird character is assigned before and after the data. The character is a square box with question mark in it. Also the same character displays on the VB form as well
[Code]...
I'm reading data from a .mdb access database to a form in my app. However the text is sometimes becoming scrambled as shown belowDatabase:Quote:The resistance of a 2.5mmonductor of length 8m and resistivity p = 1.72
View 6 RepliesMy configuration file has the following settings for logging. I want to read the Switches value attribute to see if Debug is set to 4 (Debug logging) so that I can retain some temporary files. How to I read the value using configuration manager?
HTML
<system.diagnostics>
<switches>
<add name="TraceLevel" value="4" />
</switches>
</system.diagnostics>
The code below has a green line below the text after Return. VB10 states that the context is obsolete but I cannot find a new method to get rid of it
Imports System.Configuration
Public Class Form1
Public Shared Function ReadSetting(key As String) As String
[code]......
In out app we use dll that are loaded as addins. At startup we search the config files for these dlls in the application folder.The config files are named MyAddin.dll.config. On a win2003 R2 server running terminal services (in a domain with a SBS 2008) some of the users have problems reading the config files. I get an UnauthorizedAccessException when opening the config files like this:
Dim fs As New FileStream(strfile, FileMode.Open, FileAccess.Read)
reader = New System.Xml.XmlTextReader(fs)
fs.Close()
When I rename the files to MyAddin.config this works fine. Is the OS restricting the access to xxx.dll.config files?
I need to read the keys from several external applications .config files, is it possible to specify the file for AppSettingsReader?
View 1 RepliesI have conquered the problem of the database however what i need is the serial port data sent to a database and outputted on screen however i keep getting cross thread errors ..
Imports System.Data.OleDb
Imports System
Imports System.ComponentModel
Imports System.Threading
[code]....
I've never used a List(Of) before and I'm not sure how to pass it to the Data Layer of my application. The ColResCategory is a property within the Business Layer (See below) and it needs to be passed to the Data Layer. ReplaceResCategory (See 2nd Code view) is another class file within my Business Layer and the ColResCategory references it.
Public Property ColResCategory() As List(Of ReplaceResCategory)
Get
If IsNothing(mColResCategory) Then
mColResCategory = New List(Of ReplaceResCategory)
End If
Return mColResCategory
[Code] .....
I'm creating a Data Layer for a Web Application and in one of my functions, I need to pass in a Structure full of Customer info. This Data Layer is essentially a DLL. My problem is that I'm not sure how to do this.Below is my code and what I want to do.
[Code]...
I'm using vs2010 and can't get this to work. The same code has worked in earlier versions. What has changed?
config file:
<appSettings>
<add key="ConnectionString" value="Data Source=MikeLaptop;Initial Catalog=AdventureWorksDW2008R2;Integrated Security=True"/>
</appSettings>
Code:
Dim strProvider As String = ConfigurationManager.AppSettings("ConnectionString")
strProvider is always = nothing
How to do this now?
I have multiple documents stored in Attachment data type in Access database. UsingDataReader, I need to read multiple attachments along with their file name and store them on the file system
View 1 RepliesNeed a SQL Server "SQLClient" (VB) Data Layer Class?
View 2 RepliesWe have data that's updated nightly in a database residing in the same instance as my app's database. So to save on database calls, I want to cache this static-for-the-day data into a List(Of MyObject). From a theory point of view, should this cached List(Of ) be cached in the presentation layer code, via a global variable? Should it be in a global variable in the .DLL?I'm thinking in the .DLL, because I created a service layer, which is exposed publicly to the GUI and makes calls to the data access layer inside the .DLL:
Public Shared Function Search(ByVal criteria As Core.Other.Customer) As List(Of Core.Other.Customer)
' TODO: Check the customer cache to see if it has been populated yet. If not, populate it.
If 1 = 1 Then
[code]....
If you want to go to [url]... there is a tutorial about Luna, a vb.net code generator for data Layer of application
View 6 RepliesI am a fairly rookie programmer who is trying to learn the basics of n-layered architecture (DAL, BLL, UI). The application I am programming is a single tier, 3-layer application written in VB.NET (.Net 3.5). Layers as follows:
DAL
BLL
UI
COMMON - contains DTO's right now.
I am having trouble determining what to pass between my BLL and UI. My instinct tells me that I should only pass data to the UI, and not the full business object from the BLL. Consider two scenarios:
1) Pass the BO directly from BLL to UI. This exposes BO methods and allows the UI direct access to the BO, which seems bad.
2) Pass only the pertinent data from the BO to the UI. For instance, a customer has a Name and Address. This data is really what we want to show/edit in the UI, so we would only return that data to the UI instead of the full BO. The UI would then call to the BLL to update a specific BO.
I am inclined to use #2, but I don't know the best way to implement it. The way I have it programmed now, if I only return data from the BLL, all references to my BO's will be lost and the GC will claim them. Based on this, I have some questions:
1) Should I keep business objects alive between calls to the BLL? The alternative is to re-create them every time I pass data through the BLL, which seems wrong.
2) What is the best way to keep a BO alive in a single tier architecture (how to hold a reference if we dont pass it to the UI?)
3) How do n-tier applications do this? Do they keep the BO's alive in the BLL and wait for an update from the UI? Doesn't this require a lot of "book keeping" in the BLL to make sure BO's are released when they are no longer needed?
I am using Oracle 11g client, with ODP.NET. I am trying to add conditional Transaction handling.
Dim ds As New DataSet()
Dim txn As OracleTransaction
Dim _beginTransaction as Bolean = true
Using conn As New OracleConnection(ConnString)
[Code]...
How do I fix txn being nothing / null? The error is: Variable 'txn' is used before it has been assigned a value. A null reference exception could result at runtime. Edit: to RichardOD for pointing out that you can not explicitly declare that a transaction cannot be opend up on stored procedures via ODP.NET. I have verified that this is an issue. BUT We still haven't figured out why the error is occuring. I understand that txn is initially given a value w/in an if statement, but being defined outside of the try/catch block should make that irrelevant.... right? Or is that bad coding?