I know what i want but not sure of the name and required tools so here goes... I have a few different sql tables. I want a tool that will generate an object in my .net project for each table, with each column a property of this object. (i.e. strongly typed, no datatables) I want to be able to call select, insert, update and delete met...
Suppose we are developing class which implements simple CRUD operations for working with DB. This class also maintain cache for increasing performance. public class FooTableGateway { Map<Integer, Foo> id2foo = new HashMap<Integer, Foo> (); public void getFoo (int id) { if (id2foo.containsKey (id) { return id2foo.g...
Hi all, I've started to build a Windows Forms application. The application will work in two different modes: local (1 user, opening and saving files just like a Microsoft Office application) network (multiple users, all accessing a shared database in another host of the network) For the local mode I am planning to use a SQLite embed...
I would like to ask whether or not is a good practice, to hold the CRUD operations for business objects, in a single domain service class. Should we provide a domain service class for each BO? ProductDomainService.cs CustomerDomainService.cs ... or a single BusinessObjectDomainService.cs ...
Hi, I've gotton to the point in my simple project where I'm ready to unit test the DAL. I basically have a class called FooDataAccess with several very simple functions, lets say 3 of them like this: int InsertFoo(string fooName) void UpdateFoo(int fooID, string fooName) void InsertFoosDepedency(int fooID, string someValue) What I d...
Given a stored procedure, is there a way to auto generate a Data access layer? I understand that this can be done using Codesmith by creating cs templates, but was wondering if there's a free/paid solution out there. The plan is for the architecture to have: ASP.NET code behind -> Business Layer -> Data Access layer -> Stored Procedure...
Hi, We are working on an ASP.NET application with SQL Server 2008 as backend and we are NOT using LINQ. In the application all database calls will be performed using/through stored procedures. So would anyone please suggest any free and best Data Access Framework which could do these jobs. Many Thanks, Regards. Bhavna. ...
In my SOA architecture, I have several WCF services. All of my services need to access the database. Should I create a specialized WCF service in charge of all the database access ? Or is it ok if each of my services have their own database access ? In one version, I have just one Entity layer instanced in one service, and all the other...
Our company has a product which relies on local database to work (it allows more client to connect to same database and share data between them). DBMS: Microsoft SQL Server 2008 Now, we need to create a single database, accessible through internet (i am not interested in the how, for now), which will allow more users to use it as if ...
Can anyone suggest a simple Data Access Layer (C# .NET)? Not keen on using the Microsoft Application Data Access block, seems very bloated and overkill. Also don't want to use LINQ to SQL for various reasons. I want to build upon this and create our own in-house ORM, again for various reasons. In the past I've always had the Data Access ...
I currently have an asp.net web application which is using seperate assemblies for the data access, the business logic, entity objects, and the web user interface. The data access was created using Microsoft's Data Access Application Block compilied as a .NET 2.0 assembly. Stored procedures were used for the actual moving of data in and ...
So as I understand it with good loose coupling I should be able to swap out my DAL with a couple lines of code at the application root. I have 2 DAL written, Linq-to-sql and a JSon file repository (for testing and because I wanted to try out the System.Web.Scripting.JavascriptSerializer). linq to sql will create entities instead of my ...
I'm looking at using LINQ to SQL for a new project I'm working on, but I do not want to expose the LINQ classes to my applications. For example, do an select in link returns a System.Linq.IQueryable<> collection. As well, all the classes generated to represent the database use Table, Column, EntityRef classes and attributes. It's fine...
I want to get data from my data access layer into my business layer, then prepare it for use in my UI. So i wonder: is it better to read my data by DataReader and use it to fill a List<BLClasses> or to fill a DataSet and send the DataSet to UI Layer ??. I'm interested in good performance and scalability. ...
Given a straightforward user-driven, high traffic web application (no fancy reporting/BI): If my utmost goal is performance (not ease of maintainability, ease of queryability, etc) I would surmise that in most cases, a roll-yourown DAL would be the best choice. However, if i were to choose Linq2SQL or NHibernate, roughly what kind of ...
Hi I'm creating my first linq based project. The DAL consists of LinqToSQL classes. And the logic layer is just another DLL for keeping it simple. I wanted to know how do I pass the var object (result of select query) from Login Layer to Presentation Layer? Should I write my own DTO layer between Login layer and Presentation Layer to ...
I've always had a difficult time deciding where the best place is to manage my "master" set of data structures for my data access layer. Traditionally, I've always started with a database and used a code generation tool to get a set of code models (i.e. ActiveRecord in SubSonic). Lately, however, I've been attracted by the idea of mana...
Hi, We can speed up a hibernate app easyly with 2nd level cache using infinispan or ehcache/terracotta,... but ibatis only have a simple interface to implement for caching. And hibernate knows more information about the data, so it helps for better caching, too. In the other side, the simplicity of ibatis is also the power of it and it'...
I had a client ask for advice building a simple WPF LOB application the other day. They basically want a CRUD application for a database, with main purpose being as a WPF training project. I also showed them Linq To SQL and they were impressed. I then explained its probably not a good idea to use that L2S entities directly from their B...
As I am a beginner to ASP.NET MVC, I would like to know what are the best data access methods for ASP.NET MVC? ...