crud

Creating and Updating many to many relationships in C# asp.net MVC with Linq2Sql

I have created a web app in MVC following the NerdDinner tutorial. I have 2 fields that have many to many relationship with my "dinner". For each "dinner", I need to be able to select one or more Companies from a Company table and one or more Services from a Service table. I've been reading blogs and forums for 2 days, but can't seem ...

Entity Framework: Mapped multiple Tables into one Entity -Insert problems

Hi all! Today I have an Entity Framework Question. I have two Tables: Projects and Projects_Rights Projects contains some Projects... Project_Rights contains access rights for each Identity (=User) for each Project. This Table is computed by triggers/functions. Mapping those table into one entity was no challenge: class Project {...

good jquery exention for on-the-fly CRUD

Hi I have a user profile page, and I'd like to have an extension that will let the user edit his details on the page, on the fly. The way I figure this happening is once any value is clicked (i.e., "my nickname") it is converted to an editable textarea, and on blur of said textarea, the data is submitted via ajax to the sever, and the f...

Good Ideas for Automating Common CRUD Operations in Rails

Short version: What are some good ways to allow the end user to define "processes" or sequentially executed CRUD operations in a fairly large project, so they can build templates for common processes (like creating 2 tickets for each new event posted automatically)? Something like Cucumber, but for CRUD operations..., or even Selenium? ...

I'm a pretty good C# developer, but I've never done something like this; how would I create a CRUD application generator?

I found SubSonic, but I'd rather roll my own with a few buddies. I've never done something like this before, but if you tell me technically how I should proceed, I can figure it out. I want to have a sort of visual designer. Ask the user what tables there are going to be, the relations, what fields, which are primary keys, etc. Then g...

Visual Basic 6 tutorials for data access and CRUD

Do you know some tutorials (preferably a website or a blog) in Visual Basic 6 (not Visual Basic .NET) for data access or CRUD? The caliber and depth that I'm looking for is similar to this site: Data Access Tutorials for ASP.NET http://www.asp.net/learn/data-access/ Although the above site is for web applications, I am looking for a ...

Data Adapter not able to update records added/updated/deleted in .NET

Steps, Crate window application with single form add new datasource from Data->Add new Data source Goto Data->Show Data Source Drop any table to form. This step will add tow controls. a. DataGridView b. Binding Navigator press F5 to run. I am able to view all the records but not able to do add/update/delete. Below is the code of t...

WCF Data Service / Surrogate Key

I want to build a WCF data service which should be used for CRUD operations on a database backend. In order to identify the related record of the object in the database I have to know it's primary key. I use surrogate keys in my database schema. Is it a good practice to pass the surrogate keys to the caller, so that it is possible to id...

"Automagic" output fields in CakePHP?

I'm currently using CakePHP's "automagic" field elements for my CRUD forms. By this I mean I'm using the echo $form->input('fieldname', $options); method to generate everything. This chooses the correct element type, and wraps everything into a div with a <label> element. Now I have some fields that are not editable, but i'd like f...

I need an idea for a RESTful implementation of inventory API for an RPG game.

I'm working on an kind of an RPG game. And I'm trying to figure out a nice, clean and RESTful way to define inventory API. inventory consists of several slots like head, chest etc (like in most RPG games). Now I need to define REST API to move all items from slot X to slot Y. few ideas I had: well, obviously the inventory lives at /...

crud with telerik radgrid and linq to entity

I was thinking if is it possible to do crud on telerik radgrid and the data were from a linq to entity. I was using edmx, then I have set Radgrid's DataSource with data resulting from a linq query. Here it goes: DatabaseModel.Entities entities = new DatabaseModel.Entities(); RadGrid1.DataSource = from courses in entities.Courses ...

WCF SOA: CRUD Data Access Service...why bother (or is our design wrong)?

Hello all again. We have a Data Access service in our SOA WCF system. This service is responsible for doing CRUD (create, update, delete) operations on "system wide" database tables, and is also the source of this data for queries. Any other service in the system wanting to access the tables under the contol of the DAS have to go to the...

Using GET instead of POST to delete data behind authenticated pages

I know you should use POST whenever data will be modified on a public website. There are several reasons including the fact that search engines will follow all the links and modify the data. My question is do you think it is OK to use GET behind authenticated pages in something like an admin interface? One example would be a list of pr...

Need direction in creating an application which generates a crud form

Hi all, I was wondering if anyone knew of any way i can implement an application which will do the following. Allow a user to specifiy a connection string to a sql db Allow a user to specify a table in the db Allow a user to specify columns from the specified table Generate Views, a Controller with Crud methods, & Data access code on ...

What kind of events should be created for a CRUD application?

I have an application that is centered around a database (ORM is LINQ-SQL) that has a table called Assignment. I am using the repository pattern to manipulate the database. My application is basically going to perform CRUD operations. I am new to delegates and events and I am asking you what events I should create (like maybe AssignmentC...

Is there a Drupal module for Forms with powerful CRUD style behaviour?

We are building a website that contains a large number of database tables that need to be edited by the CMS administrator. Some of the tables are fed by form submissions from users on the front end of the website. Some of the tables are purely in the CMS and are used to create custom modules on the front end of the website. Although the...

Do I really need bindParam?

Hi there! I'm trying to do a little PDO CRUD to learn some PDO. I have a question about bindParam. Here's my update method right now: public static function update($conditions = array(), $data = array(), $table = '') { self::instance(); // Late static bindings (PHP 5.3) $table = ($table === '') ? self::table() : $table; ...

Factory pattern vs ease-of-use?

Background, I am extending the ASP.NET Membership with custom classes and extra tables. The ASP.NET MembershipUser has a protected constructor and a public method to read the data from the database. I have extended the database structure with custom tables and associated classes. Instead of using a static method to create a new member...

How generate the SQL queries that match the JPA Entity CRUD operations at build time with Hibernate

Given JPA annotated Entities, is it possible to generate (i.e. before runtime) the list of queries that will be performed by Hibernate for CRUD operations (performed against EntityManager) ? For named queries it is possible using org.hibernate.hql.QueryTranslator Any pointer into the Hibernate API will be appreciated. ...

Examples of WPF forms for usual CRUD scenarios

There are plenty of such examples shown for Silverlight at recent Microsoft conferences ( Creating amazing LOB applications in SL 2,3,4 ... ) . They even invented DataForms starting from Silverlight varsion 3. Basically I need an example of grid view ( maybe with possibility to filter, preferably DataGrid control ) from which we may ...