.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

Adjacency list model or ?

Posted By:      Posted Date: September 25, 2010    Points: 0   Category :ASP.Net

Hi everyone,

Classic scenario - Categories, Subcategories and Products tables.

Subcategories belong to a corresponding main category

Products belong to a corresponding subcategory

The problem is that not all products do that. Some of them belong directly to a main category because that category has no subcategories. So if I wish to query those products I have to use a main category field in the products table.

And of course I need a subcategory field in the products table also for those products that do belong to a subcategory.

All that does not seem like a good normalized schema.

Now if I use the Adjacency list model the categories and subcategories tables become one (parentID column) and I only have to use a single CatId in my queries.

Is that a good technique or is there some other more correct way to do it.


View Complete Post

More Related Resource Links

How to get List ContentTypes using ECMAScript Client Object Model?

Hello SharePoint Experts, I have a document library in SP 2010 site which also has a custom Ribbon button. The user can select either a folder or a document/List Item from the document library. I want to disable the custom Ribbon button if the user selects the folder and enable it when the user selects document/List Item. I want to do all this using JavaScript/ECMAScript Client Object Model. I tried many things,but could not do it yet. I know I how to check if the currently selected item has a Folder ContentType or an Item ContentType. Code: var _clientContext = new SP.ClientContext.get_current(); var _web = _clientContext.get_web(); var _list = _web.get_lists().getById(SP.ListOperation.Selection.getSelectedList());                                  _clientContext.load(_list, 'Title', 'Id'); _clientContext.executeQueryAsync(Function.createDelegate(this, onListLoaded), Function.createDelegate(this, onListFailed)); function onListLoaded(sender, args) {                                   alert('onListLoaded...');        &n

Client Object Model : Transactional update of list and content types

I am using Silverlight client object model to code against Sharepoint. Essentially, what I want is that when a user clicks a button, An item needs to be added to a list and also a new content type has to be created. button1_click() { //1. Create an item in a list. //2.  Create a new content type. } Also this should be transactional:  only if item is added should the content type be added too, otherwise roll back both. (and vice-versa). My understanding of client object model is that we at the core we are talking to Sharepoint WCF services. So if I say, using(TransactionScope scope = new TransactionScope()) { ClientContext.ExecuteQueryAsync(); scope.Complete(); } can I assume that the updation will be transactional??

Create List Sharepoint Client Object Model Access Denied



I am trying to create a silverlight application by making use of the SharePoint 2010 Client Object Model using the following code:

private void CreateList(object sender, ClientRequestFailedEventArgs e)
  ClientContext ctx = new ClientContext("http://server");
  ListCreationInformation lc = new ListCreationInformation();
  lc.Title = "FlexiTime";
  lc.Description = "";
  lc.TemplateType = (int)ListTemplateType.GenericList;
  List newList = ctx.Web.Lists.Add(lc);
  System.Threading.ThreadPool.QueueUserWorkItem(new WaitCallback(CreateListCallback), ctx);

private void CreateListCallback(object s)
  var context = (ClientContext)s;  

The error I receive is as follows:


Silverlight Client Object Model - List Fields Names


I'm trying to get the DisplayName of the Fields of a list through the Client Object Model (Silverlight)

I can retrieve the fields of a list as an authenticated user but not as anonymous: getting list.fields as anonymous simply returns Access Denied.

Is there a way to enable list.fields for the Client Object Model?

Or is there any other way of getting the DisplayName of Fields of a List?

Urgent!!!How can we sort the parameter list in report created using report model in ssrs 2008 r2?


How can we sort the parameter list in report created using report model in ssrs 2008 r2? Do I need to change some property in Model or elsewhere?


Model with List as member: Member alwasys NULL after submit



I have following model class:

public class WebModel
    public List<ArticleModel> Articles { get; set; }

public class ArticleModel
    public int ID { get; set; }       

    public double ValueParam { get; set; }

Then I have the controller with the two actions:

public ActionResult Index()
      WebModel model = new WebModel();
      ModelConverter.ConvertToModel(model, controller);    
      return View(model);

public ActionResult Index(WebModel model, string saveButton)
      ModelValidation.ValidateWebModel(model, ModelState);
      if (ModelState.IsValid)
                return RedirectToAction("Create", "Article");

Binding WPF Controls to an Entity Data Model

In this interview, programming writer, McLean Schofield, demonstrates how to bind WPF controls to an entity data model, using Visual Studio 2010 Beta 1. You can also learn more in the topic: Walkthrough: Binding WPF Controls to an Entity Data Model.

Model View Controller (MVC) for ASP.NET

Model View Controller (MVC) architectures, immediately wonder how the MVC pattern can be applied in an ASP.NET world. This article will demonstrate how the MVC pattern can be applied to an ASP.NET web application and still maintain the basic Microsoft supplied architecture.

Dynamic Systems Development Model (DSDM) Methodology

The Dynamic Systems Development Model was developed in the U.K. in the mid-1990s. It is the evolution of rapid application development (RAD) practices. DSDM boasts the best-supported training and documentation of any of the agile software development techniques, at least in Europe. DSDM favors the philosophy that nothing is built perfectly the first time and looks to software development as an exploratory endeavor.

Ready made List Types provided by SharePoint

SharePoint provides some out of the box List Types. Some of the most used ready made list types that SharePoint provides currently are listed below:

Export SharePoint List to Excel Spreadsheet Programmatically using C#

In SharePoint applications, Custom Lists are used to store business data and Document Libraries to store the documents. But for data manupulation and analysis, Microsoft Excel provides very rich features as compared to SharePoint Lists. That's why people still loves to work on Microsoft Excel Sheets.

Overview of SharePoint Object Model

SharePoint offers a set of structured server-side objects those are widely used to program SharePoint Applications. These objects are hierarchically arranged and you can drill down through the object hierarchy to obtain the object that contains the components of SharePoint Application you need to use in your code.

Binding WPF Controls to an Entity Data Model

In this interview, programming writer, McLean Schofield, demonstrates how to bind WPF controls to an entity data model, using Visual Studio 2010 Beta 1. You can also learn more in the topic: Walkthrough: Binding WPF Controls to an Entity Data Model.

Dropdown list in ASP.NET - How to get value selected

am sure this must be very simple, but unforunately I can't figure it out.
I have the following code which populates the dropdown lists from the database. This works fine. Now, when the user selects a particular employee name from the list, I want to get the Employee Id of the selected employee. i.e. I need to get the "Eid" value. I can do this if the EId is loaded in the dropdown list, but in this case only the employee name is displayed. Please let me know howI can get the Eid value even though it is not loaded in the dropdown list.
I would really appreciate your help

Creating Sites/Lists/List Items under Current User Context in SharePoint By Using SPUserToken

Usually we do this by performing the action under RunWithElevatedPrivileges method and updating the listitem using SPListItem.SystemUpdate() method (see here). but this approach has its own flaws like (RunWithElevatedPrivileges will run under system account, we cannot use SystemUpdate for SPSite,SPWeb,SPList, since it runs under system we will "CreatedBy" by as SystemAccount).

Editable Gridview with Textbox, CheckBox, Radio Button and DropDown List

This is an example of an editable gridview containing different ASP.NET controls. When user wants to edit values in gridview, she/he can use these controls to edit existing values in Gridview Edit Mode.

Using the Code

Get pixel format, raw format, property id list and property items image in VB.net - C#.net.

n this simple article you will learn that how we can get pixel format, raw format, property id list and property items image in VB and C#.net.

Get Pixel Format:

Image consists of pixels to get the format of the pixel we have a property named pixel format. This property returns an enumeration of pixel format. This enumeration tells the pixel format.

To demonstrate make a window application. Drag one button and a picture box on form.

Now write the following code on Button click event:
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend