Thread: [Rainbowportal-devel] New DAL
Brought to you by:
danijel_kecman,
manudea
From: manu <ma...@du...> - 2004-09-29 17:29:32
|
Well... I prefer moving further for 2 reasons: - Drop stored procedures entirely (the supposed better performance is = not true... and in many case sp act bad than ad hoc sql) - Move toward db independence. At present we have 2 options: - llblgen (maybe better for core) http://www.llblgen.com/pages/features.aspx This is a DAL generator so code have to be generated by the tool but supports many templates including SQL, Access and oracle and gentle, better for modules since it is all db agnostic. http://sourceforge.net/projects/gopf ------------------------------------ Emmanuele De Andreis Technical Manager DUEMETRI Internet Solutions Provider RAINBOW PORTAL Main portal - http://www.rainbowportal.net Sourceforge CVS - http://sourceforge.net/projects/rainbowportal/ Support Forums - http://forums.rainbowportal.net Bug Tracker - = http://sourceforge.net/tracker/?group_id=3D66837&atid=3D515929 -----Original Message----- From: Jakob Hansen [mailto:han...@ho...]=20 Sent: marted=EC 28 settembre 2004 18.24 To: rai...@li... Cc: ma...@du...; sc...@co... Subject: RE: [Rainbowportal-devel] Helper on the Generic DAL front.... Hi Guys. In the meeting 22. august I promised to look into a database=20 provider pattern for Rainbow. The zip contains an example of a working=20 version (with module Announcements only). Perhaps the zip is missing from this email because it is a list... Drop = me a mail and I'll send you it. Later I put this example on Rainbow download=20 area. I based the solution on open source Data Access Application Block (aka.=20 DAAB) version 3.1 code that you can find on GotDotNet. The 3.1 release=20 implements the abstract factory pattern, and lets you use different data = sources based on the available .NET Data Providers. Note that I used DAAB "as is". I did not change the DAAB code. I only = added=20 the GotDotNet.ApplicationBlocks.Data.dll to the project. In the zip are all the Announcements files from version "1.4.0.1771c -=20 17/08/2004" and 3 extra files. All following listed files did I modify: - AnnouncementsDB.cs (I left the old code in comments) - AnnouncementsEdit.aspx.cs (changed one line: SqlDataReader to = IDataReader) - Web.config (added some keys after "<!-- Ado Database Provider...") - PortalSettings.cs (Search for region "Ado Database Provider") - rb_AddAnnouncement.sql (a minor change to do a better solution. Make=20 backup before you run!) The big changes are in AnnouncementsDB.cs. If you look at the code it = has=20 become a more simple (and there is less of it). Some of the code I put in PortalSettings.cs should really be placed=20 elsewhere, but to show a simple solution I keept it there. Will it be in Rb 1.0? Absolute not! Maybe later! Something like this = example is the first step to make a Rb that will run on many different databases = (Note that this is a fully working version on SqlServer!). To not delay = Rb=20 1.0 please regard this example of how we could do it - lets defer heavy=20 discussion until after Rb 1.0 is released. For the Mono guys: Please = give it a test send me some feedback! Go ahead and send me any comments or questions. Cheers Jakob |
From: Joerg S. <j.s...@fe...> - 2004-09-29 19:03:37
|
Hi there, Manu wrote: > At present we have 2 options: > - llblgen (maybe better for core) > http://www.llblgen.com/pages/features.aspx If I see it right...we have to pay for that product. It is may OK...but, does it help us to bring us forward with rainbow? > and gentle, > better for modules since it is all db agnostic. > http://sourceforge.net/projects/gopf Without own testing...what do you prefer? What is the advantage/disadvantage of both "products"? kind regards Joerg |