I'm developing a large website with a substantial number of large forms -
containing 40+ fields each. Writing the INSERT and UPDATE statements by hand
is extremely laborious and time consuming. I can't simply bind to a datagrid
-- each form is wrapped in a custom design and extensive business and
presentation logic prevents me from using generic controls. Instead, I'm
writing SQL Statements and passing each field as a separate command parameter
-- after sanitizing and running checks -- which leads to mountains of code to
accomplish a relatively simple task.
I've worked with Ruby on Rails and Active Record is a joy. I dream of the
day when I can create an object, assign properties, and run a save method on
the object which "automagica lly" writes the INSERT or UPDATE sql for me.
I want to find out what tools other developers are using to solve this
problem. I can't believe that there isn't a better way to accomplish this
task.
I'm not interested in Castle on Rails, or other projects that require a
non-ASP.NET workflow. I like the .NET framework and I want the ORM layer to
be as minimal as possible.
I'm not interested in Code Generation either. It's unacceptable to have to
"re-generate" code for every change. I should be able to quickly add an
attribute and not worry about having to deploy a large number of
supplementary files.
I'm looking for something that is secure and very lightweight. Does anything
exist? What tools do you use for ORM?
Thanks in advance for your advice.
3  1895 
There are hordes of such tools. You should have taken a closer look at
castle project who have a library ActiveRecord which is built on top of
nhibernate that does exactly what you are describing. You can use this
library with a normal ASP.NET workflow (i.e. you don't have to use
everything they have).
Cheers,
Greg Young
MVP - C# http://codebetter.com/blogs/gregyoung
"Brenden Bixler" <Br***********@ discussions.mic rosoft.com> wrote in message
news:7D******** *************** ***********@mic rosoft.com... I'm developing a large website with a substantial number of large forms -
containing 40+ fields each. Writing the INSERT and UPDATE statements by
hand
is extremely laborious and time consuming. I can't simply bind to a
datagrid
-- each form is wrapped in a custom design and extensive business and
presentation logic prevents me from using generic controls. Instead, I'm
writing SQL Statements and passing each field as a separate command
parameter
-- after sanitizing and running checks -- which leads to mountains of code
to
accomplish a relatively simple task.
I've worked with Ruby on Rails and Active Record is a joy. I dream of the
day when I can create an object, assign properties, and run a save method
on
the object which "automagica lly" writes the INSERT or UPDATE sql for me.
I want to find out what tools other developers are using to solve this
problem. I can't believe that there isn't a better way to accomplish this
task.
I'm not interested in Castle on Rails, or other projects that require a
non-ASP.NET workflow. I like the .NET framework and I want the ORM layer
to
be as minimal as possible.
I'm not interested in Code Generation either. It's unacceptable to have to
"re-generate" code for every change. I should be able to quickly add an
attribute and not worry about having to deploy a large number of
supplementary files.
I'm looking for something that is secure and very lightweight. Does
anything
exist? What tools do you use for ORM?
Thanks in advance for your advice.
In fact Ayende just put up a post about it yesterday :) http://www.ayende.com/Blog/PermaLink...9883cb6ad.aspx
Cheers,
Greg Young
MVP - C# http://codebetter.com/blogs/gregyoung
"Greg Young" <dr************ *******@hotmail .com> wrote in message
news:O%******** ********@TK2MSF TNGP03.phx.gbl. .. There are hordes of such tools. You should have taken a closer look at
castle project who have a library ActiveRecord which is built on top of
nhibernate that does exactly what you are describing. You can use this
library with a normal ASP.NET workflow (i.e. you don't have to use
everything they have).
Cheers,
Greg Young
MVP - C#
http://codebetter.com/blogs/gregyoung
"Brenden Bixler" <Br***********@ discussions.mic rosoft.com> wrote in
message news:7D******** *************** ***********@mic rosoft.com... I'm developing a large website with a substantial number of large forms -
containing 40+ fields each. Writing the INSERT and UPDATE statements by
hand
is extremely laborious and time consuming. I can't simply bind to a
datagrid
-- each form is wrapped in a custom design and extensive business and
presentation logic prevents me from using generic controls. Instead, I'm
writing SQL Statements and passing each field as a separate command
parameter
-- after sanitizing and running checks -- which leads to mountains of
code to
accomplish a relatively simple task.
I've worked with Ruby on Rails and Active Record is a joy. I dream of the
day when I can create an object, assign properties, and run a save method
on
the object which "automagica lly" writes the INSERT or UPDATE sql for me.
I want to find out what tools other developers are using to solve this
problem. I can't believe that there isn't a better way to accomplish this
task.
I'm not interested in Castle on Rails, or other projects that require a
non-ASP.NET workflow. I like the .NET framework and I want the ORM layer
to
be as minimal as possible.
I'm not interested in Code Generation either. It's unacceptable to have
to
"re-generate" code for every change. I should be able to quickly add an
attribute and not worry about having to deploy a large number of
supplementary files.
I'm looking for something that is secure and very lightweight. Does
anything
exist? What tools do you use for ORM?
Thanks in advance for your advice.
Thanks Greg.
I was under the impression that Active Record / Monorail was tightly
coupled, but it appears that I can use Active Record without modifying the
ASP.NET workflow.
The links and guidance are appreciated.
-Brenden
"Greg Young" wrote: In fact Ayende just put up a post about it yesterday :)
http://www.ayende.com/Blog/PermaLink...9883cb6ad.aspx
Cheers,
Greg Young
MVP - C#
http://codebetter.com/blogs/gregyoung
"Greg Young" <dr************ *******@hotmail .com> wrote in message
news:O%******** ********@TK2MSF TNGP03.phx.gbl. .. There are hordes of such tools. You should have taken a closer look at
castle project who have a library ActiveRecord which is built on top of
nhibernate that does exactly what you are describing. You can use this
library with a normal ASP.NET workflow (i.e. you don't have to use
everything they have).
Cheers,
Greg Young
MVP - C#
http://codebetter.com/blogs/gregyoung
"Brenden Bixler" <Br***********@ discussions.mic rosoft.com> wrote in
message news:7D******** *************** ***********@mic rosoft.com... I'm developing a large website with a substantial number of large forms -
containing 40+ fields each. Writing the INSERT and UPDATE statements by
hand
is extremely laborious and time consuming. I can't simply bind to a
datagrid
-- each form is wrapped in a custom design and extensive business and
presentation logic prevents me from using generic controls. Instead, I'm
writing SQL Statements and passing each field as a separate command
parameter
-- after sanitizing and running checks -- which leads to mountains of
code to
accomplish a relatively simple task.
I've worked with Ruby on Rails and Active Record is a joy. I dream of the
day when I can create an object, assign properties, and run a save method
on
the object which "automagica lly" writes the INSERT or UPDATE sql for me.
I want to find out what tools other developers are using to solve this
problem. I can't believe that there isn't a better way to accomplish this
task.
I'm not interested in Castle on Rails, or other projects that require a
non-ASP.NET workflow. I like the .NET framework and I want the ORM layer
to
be as minimal as possible.
I'm not interested in Code Generation either. It's unacceptable to have
to
"re-generate" code for every change. I should be able to quickly add an
attribute and not worry about having to deploy a large number of
supplementary files.
I'm looking for something that is secure and very lightweight. Does
anything
exist? What tools do you use for ORM?
Thanks in advance for your advice.
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics | |
by: M.L. Abram |
last post by:
Hello all,
I do not know if this question is regarding table design, queries, or
programming. Below, I have given a table design using Access 2003.
Fields 'Product' and 'Color' are primary keys and 'Active'
is a Boolean data type. What I am trying to accomplish is having only
one record selected active out of the 'Product' field for each
type. If possible, have the user be able to do this task while viewing
the data within a...
|
by: kenneth.m.mcdonald |
last post by:
First, I don't intend this to be a flame war, please. Python
and Ruby are the only two languages I'd willingly work in
(at least amongst common languages), and TurboGears and
Rails seem roughly equivalent.
I'm much more knowledgable about Python, but that's a minor
issue--I've been intending to learn more Ruby anyway.
Here are the pros and cons that I'm aware of and consider
important:
|
by: jabirahmed |
last post by:
any idea which is the best ??
|
by: Ccraig |
last post by:
Hello, I am new to this and have run into a problem. I have edited a column in MySql and I can see that it works fine. The problem I have is I need to refresh the view (hope thats the right term) to show the change. I have looked and come up with:
class test < ActiveRecord::Base
before_destroy :change_field
def change_field
self.filed='0'
update
test.reload()
|
by: raddrummer |
last post by:
I think I'm close on this one but just need a bit of help! I have a subform that has the results of a query listed in a table view. I want the user to be able to click on a record and have that feed the information of that record to a query that will ultimately output to a chart.
I thought putting the Me! reference at the beginning of the location string would do it but it's not working.
Here's what I have so far...
ANn ideas???
...
| | |
by: cynicon |
last post by:
Thank you guys for answering my last questions.
Here is again a simple question with a simple answer I suppose...
I need to know how to set in a Variable, the value of an especific column of the active record, so lets be more explicit; in column number 5 that is called "POLICY" of the active record, there is a value I neeed to know, in excel VBA i would do this:
myvar = activecell.offset(0,5).value
What would be the code for an...
|
by: banderson |
last post by:
Hello Bytes,
I am having trouble copying a value from an open record in a recordset into a form.
I have a form frmOutreachReferral that is filled in after a Site Visit has been performed and it is determined that the site needs a follow up visit.
A Site Visit is entered into frmSV and is based on tblOutreachAdmin with its primary key (autonumber) field called OutreachID. If a referral is needed, you click on a button to open...
|
by: sarge721 |
last post by:
I want to send a report to the currently selected student in my database. I have everything working fine, except pulling the e-mail address from the form. Rather than reading what I am writing as code, it literally puts !! into the TO: of the message. Stu_Email is a field on the form where the e-mail address of the current student is displayed. Thanks!
Private Sub cmdSendEmail_Click()
On Error GoTo Err_cmdSendEmail_Click
Dim...
|
by: Virtuo |
last post by:
Hi people...
I am new to dotNet, specially to ADO.NET Entity framework. I have a problem... I can not find a way to get field value from current active row! Here is a code I use :
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
| | |
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| | |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| | |
