nomaneagle
Last Activity: Aug 10 '10, 11:05 PM
Joined: Nov 6 '08
Location: Ontario, Canada
-
No I don't use any ORM framework. I will be using BLL and DAL as web services while my windows and web interfaces will be using them for data transmission. -
I just recently deployed the latest version of my application. So Im thinking that I should deployee the next version in the form of Web Services. Do you think its a good idea?Leave a comment:
-
Thanks Fernando Mello,
Actually this is exactly what I was looking for. But I done know much about Web Services or WCF. Also it is not a web based application. Should I use my DAC/BLL as Contract/Server? I provide you the structure of my classes so that you can have better idea about the structure of my application:
Data Access Layer:
...Code:Public Function GetList() As DataSet TryLast edited by Curtis Rutland; Aug 10 '10, 08:43 PM. Reason: Please use [CODE][/CODE] tags when posting code.Leave a comment:
-
Fantastic. I can use triggers to update the stamp table with new stamp at the time of new, edit or delete operations. Thanks very much for your help.Leave a comment:
-
I like your idea of updating generic class with latest records only if new changes are available in the table.
I do have datetime stamp for each row in the table. So in this way before I retrieve thousands of records using DAL and update them into generic class BLL with loop, I will check the existance of new records first in the table. But even in this case, if I find one new row in the table I will have to update all thousands...Leave a comment:
-
How to use Generic Class as Service
Hi,
My question could be silly but this is what I am trying to do here with my Generic class.
I have a Data Access Layer, Business Logic Layer and a presentation Layer(Windows forms). Everytime I have to retrieve a List of records, I have to call a method (GetList()) in Bussiness Logic class which calls SQL query in Data access class. I create a new instance of business Logic class everytime a user LogIn. So in this... -
Load data into a Generic class without loop
ok this is the thing I have right now which is working quite well beside its a bit slow:
Public Function GetList() As List(Of SalesOrder)
Try
Dim list As New List(Of SalesOrder)
Dim ds As DataSet
ds = cls.GetSalesOrd erList 'CLS is the data access class
For i = 0 To ds.Tables(0).Ro ws.Count - 1
Dim row As DataRow = ds.Tables(0).Ro ws(i)
Dim kk As... -
How to Load a Generic class without Loop
ok this is the thing I have right now which is working quite well beside its a bit slow:
Public Function GetList() As List(Of SalesOrder)
Try
Dim list As New List(Of SalesOrder)
Dim ds As DataSet
ds = cls.GetSalesOrd erList 'CLS is the data access class
For i = 0 To ds.Tables(0).Ro ws.Count - 1
...
No activity results to display
Leave a comment: