I am creating a quick and dirty prototype (C#) of an object-relational mapping tool. I would like to support at least two kinds of databases - one will be Microsoft SQL Server 2005/2008 and the other most probably MySQL. Is there any way to use a single data base access mechanism for both database engines and what would it be? Of cour...
If I implement some simple OR/M tool, where do I put identity map? Obviously, each Repozitory should have access to its own identity map, so it can register loaded objects (or maybe DataMapper is the one who registers objects in IdentityMap?). And when I commit unit of work, I also need to access the identity map to see which entity is ...
Hello, I’m new to PLINQO, I’m fairly new to LINQ2SQL and I’m adding a new DAL (called DAL2) in parallel with our old existing DAL. Our idea is to start using linq2sql for every new thing we add and slowly start moving old DAL usage to the new DAL2. As we all know, DLINQ is nice for simple things but in more complicated scenarios (many...
Hello, I am preparing a new Windows project and wonder what kind of DAL technology to use. Originally I was looking for something simpler to not spending too much time on building it. But I understand also that it has to be efficient and scalable in the long run. I plan to use WPF (MVVM) Client and WCF Service on a 3 Tier system. Just...
Is there any testing framework for Data access tier? I'm using mysql DB. ...
Dear All! After reading tons of articles over the net about best-practise application-design and pattern I still cannot merge all the information together and map on my real-word-application... I would like to have a 3-tiered application: UI-Layer:A silverlight-application hosted within an ASP.net - Webapp BusinessLogicLayer:WCF-Serv...
I am using nHibernate. My classes are POCO, that map 1:1 with my database tables. I created a IGenericDAO -> GenericDAO that does all my basic CRUD. (repository) Each table has a DAO class, so: public class UserDAO : GenericDAO Any table specific queries will go in the tableDAO class. I then have a factory, IDAOFactory. public class ...
I have been reading the MSDN article at http://msdn.microsoft.com/en-us/magazine/cc700340.aspx But was wondering if there are other / alternatives best practices to using the Entity Framework (.net framework 3.5 sp1) in an asp.net , n tiered application. ...
How are DAOs usually designed for the typical business application ? Does one class or pattern dialogue with the data source or do you simply have a separate DAO for each Entity ? ...
In an environment with a SQL Server failover cluster or mirror, how do you prefer to handle errors? It seems like there are two options: Fail the entire current client request, and let the user retry Catch the error in your DAL, and retry there Each approach has its pros and cons. Most shops I've worked with do #1, but many of them...
So I've got this data access layer, and I also want to log to the database. In the spirit of eating my own dog food, I want to use my data access layer to do the logging. However, I also want to log the data access itself. Like so: App || V Log || V Data=>Log Am I at risk of getting into a feedback loop? If so, how should I avoid it? ...
I am working on a Data Access Layer Design, we have not finalized what ORM we are going to use as of yet. I am leaning towards NHibernate + FluentMappings + Nhibernate.Linq but depending on project timelines we could even wait for EF4. I want to replace methods like : IList<Customer> FindById(int id); IList<Customer> FindByName(string ...
I have just encountered the MS Enterprise Application Library 3.1 in an application I need to support/enhance. I am trying to get up to speed quickly on Microsoft.Practices.EnterpriseLibrary.Data in particular. The doc on this is quite good but the reading is vast and I am curious about one aspect of this: Years ago when .Net 1.0 firs...
is this good style of java data access code, or is it too much try finally ? public List<Item> getItems() throws ItemException { ArrayList<Item> items = new ArrayList<Item>(); try { Connection con = ds.getConnection(); try { PreparedStatement pStmt = con.prepareStatement("SELECT ...
I'm trying to work with java data access, so this with what I came up with: Tell me what do you think about this (It's a little bit like SqlConnection from C#) import java.sql.*; public class SqlConnection { Connection connection; public Connection GetConnection() {return connection;} public void Connect(String cs, Strin...
i have a data access layer that abstracts the rest of the application away from the persistence technology. Right now the implementation is SQL server but that might change. Anyway, i find this main data access class getting larger and large as my tables grow (about 40 tables now). The interface of this data access layer is any questi...
Hi, I'm looking for a java library thats similar to .NET's Enterprise Library specifically the Data Access block. More details.. working on a java poc and would like a library to build the data access.. no ORM's or something too complicated. The library should be able to use MsSQL as a database. ...
Hi, the question is very straightforward: Good DAL library for PHP which has the similar .Net's feature: command.Parameters.AddWithValue("@demographics", demoXml). mysqli extension is good but I want to have the aforementioned feature too. Putting many "?" does not look nice and rather confusing when a table has many fiends (>= 8). Than...
I'm not entirely convinced of the benefits of a 3-tier architecture. Why, then, has LINQ emerged, which is a lighter data access approach? Any input would be appreciated. ...
I am trying to write my first true multi layered application and I was wondering in a winform application does it "break" the DAL/PL separation rules if I were to add an object data soure to the form so I could use data bound controls instead of going through my BLL and then to the DAL to get the data? Thanks. ...