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


Top 5 Contributors of the Month
Easy Web
Imran Ghani
Post New Web Links

Database structure visualization

Posted By:      Posted Date: October 14, 2010    Points: 0   Category :WPF
 

Hi All,

Please be patient with me, as I am new to the forums!

I am currently developing an application that creates a database such as the following:

DatabaseRoot

  Model1

      Point1

      Point2

      Line1

      Line 2

  Model2

    Point1

    Line1

  Results1

  Results2

I would like to display this data in a treeview so that I can expand / collapse each level of the database at a group level (Models / Results at the first level, Points / Lines etc at the next sub-level).

My database objects all derive from a base object class, and each database object stores it's type (from an enum).

What is the best way to approach this, i.e. nested collectionviewstructures etc? Or should I consider re-coding the database structure itself to make it lend itself to WPF?

Cheers

Chris




View Complete Post


More Related Resource Links

Database Visualization Tools

  

Hello MSDN Hive Mind,

This is a newb question, but help would gratefully appreciated.

What tools are available for 2005 SQL Server Management Studio that allows developers to view the dependencies within a database?

I am taking over a project with no documentation and am seeking a way to view the FK within the database without having to go through every single table in the tree.


Copying a database structure (with or without data)

  

I designed a database on my local machine (cert.mdf), and attached it to SQL Server Mgmt Studio.  I signed up with a db hosting company and copied it to their site (using "script database as / create to") and got it set up out there.  Since then I've made further changes to the design, but only to the web-based version.

Now I'd like to bring the web-based design back to my local cert.mdf so I can do some further development & testing but I can't seem to find a way to do that.  (I don't mind being destructive on my local machine).  If I try the same thing but in reverse, I get a 'metadata unreadable' error.  If I just try a copy (via mgmt studio) I get a message about 'unable to connect to local server'.

Suggestions?


FBA with custom database structure

  

Hi, 

I'm trying to setup FBA for SharePoint 2010 in my environment. 

I've written my  custom membership provider that communicates with my custom SQL database - i'm not using default SQL FBA database for this. 

I've implemented login/registration controls for user creation and authentication. 

I'm using only membership not role provider (i don't need to validate any roles !)

When i debug the application, everything seems to work fine as far as communicating to my custom database is concerned, i can debug my application properly. perfect

but somehow, i'm not able to setup the FBA working. 

in my extended web application - when user is validated - i get 500 error - saying that user could not be validated. As far as i have seen - this is because claims authentication fails for that user !

i've followed all the steps to configure FBA for SharePoint 2010 but still this is not working fine. 

 

I've modified the web.config for central administration site 

added in web.config  - connection string and membership provider

same for STS web.config- my web application and extended web application 

in extended web app i've setup default claims membership provider as the default (i) - as it was mentioned in many of the blogs. 


Database structure for Rating articles

  

I'm trying to construct a article page, where people can rate the article. Currently, I have a table Articles, that stores the articleId, articleContent, and few other information. And a Rating table where I store userid, articleid and rating.

Article_Table

articleId, articleContent


Rating

userId, articleId, rating


My worry is, there can be several users rating, several articles. The Rating table is growing exponentially. There are NxM entries in my rating table for N users and M articles.

Is there a better way to design my database, so I won't run into a huge Rating table, and help reduce the time the below query takes to run.

select sum(rating)/count(*) where articleId = 'x' -- to calculate the average rating for a give article


Thanks in Advance!!!



FBA with custom database structure

  

Hi, 

I'm trying to setup FBA for SharePoint 2010 in my environment. 

I've written my  custom membership provider that communicates with my custom SQL database - i'm not using default SQL FBA database for this. 

I've implemented login/registration controls for user creation and authentication. 

I'm using only membership not role provider (i don't need to validate any roles !)

When i debug the application, everything seems to work fine as far as communicating to my custom database is concerned, i can debug my application properly. perfect

but somehow, i'm not able to setup the FBA working. 

in my extended web application - when user is validated - i get 500 error - saying that user could not be validated. As far as i have seen - this is because claims authentication fails for that user !

i've followed all the steps to configure FBA for SharePoint 2010 but still this is not working fine. 

 

I've modified the web.config for central administration site 

added in web.config  - connection string and membership provider

same for STS web.config- my web application and extended web application 

in extended web app i've setup default claims membership provider as the default (i) - as it was mentioned in many of the blogs. 


is it possible to import the content and structure of an xml file into a database

  
directly creating the table structure and name as it was in access 2007 ???
claudio cannella

Multiple database support with Entity Framework

  
One of the features introduced in Entity Framework is being database independent. Which mean each database provider can support Entity Framework by implementing its provider.

This feature allows you build applications independent from the underplaying database provider. In this post I'm going to show how to build an application that support multiple databases using same conceptual model made by Entity Framework.

Export Visio Database Table Names to Excel

  
If you use the Enterprise Architect edition of Microsoft Visio for data modeling regularly, then there is a good chance that at some point you've wanted to export just the table names into Excel. You might want to do this to map logical ERD entities to physical data model tables, track project status by entity, or track overlap between database versions.

MS SQL Server: Disconnect Users From Database - Kill User Session

  
If you ever wanted to restore your database from a SQL backup file (.bak), but there are still users connected to your database, the backup operation will fail causing the error: Exclusive access could not be obtained because the database is in use.

Publishing SQL Server Database using Publishing Wizard : Tips & Tricks

  
We can use SQL Server Publishing Wizard to deploy our local Database to remote hosting server/production server.This feature is available in SQL Server 2008/VWD 2008.

Below is the complete step by step guide of this process.

Adding Rows in GridView without using a Database

  
This article describes on how to add rows in GridView without using a database. Basically the GridView will be populated with data based on the values entered in the TextBox on Button Click and retain the GridView data on post back.

Adding Multiple Columns and Rows in GridView without using a Database

  
This article describes on how to add multiple columns and rows in GridView without using a database. Basically the GridView will be populated with data based on the values entered in each TextBoxes on Button Click and retain the GridView data on post back.

ASP.NET Database Tutorial

  
This tutorial will show you how to display data using the .NET GridView Control, ASP.NET 2.0 and VB.NET

The GridView control is a powerful tool and is simple to implement.

First, you will need to import the System.Data.SqlClient namespace.

Connestion string create any database server

  
This links important to how to create connection string to any data base sever.

SQL Server Database Transaction

  
A transaction is a group of SQL commands executed together as a single component of work to be accomplished. If all of these commands succeed, then a transaction is committed - the changes to the data are made final. If any of the commands within a transaction fail, then the entire transaction is cancelled, or in SQL Server terms, the transaction will be rolled back.

Transactions are one of the things that keep your data safe, but they're not necessarily easy to understand. Here's some help:

Database Export Wizard for ASP.net and SQL Server

  
A step wizard for ASP.net to export database objects to CSV, TXT, HTML, XML, or SQL. it guides users through a few simple steps to choose a database object (table, view, or query), select columns, and export the data in any of the standard formats CSV, HTML, XML, or SQL.

Reading and Writing Images From a Windows Mobile Database using UltraLite 10(C#)

  
Periodically I get a request for information on how to read and write binary data to a database running on Windows Mobile. If you search the Internet you can typically find examples that are available on Windows Desktops or allow you to read and write to a local file system. The problem is that it can take a bit of work to get this code to work on Windows Mobile accessing a database.

Ultimately you might be asking, why would I want to store and image in a database? Well in an environment where you synchronizing data between a local mobile database and a consolidated (central) database this can be extremely useful. Imagine if an insurance adjuster went to an accident scene, took a picture of a damaged car, loaded it into his Windows Mobile database and then replicated that image up to the Insurance headquarters for approval. All of this could be done in a very short period of time when using images in the database. Another good example might be a doctor who was waiting for a patient chart to become available. If you could store the image in a database this chart could be sent down to the doctor's device once it became available.

For this article I am not going to get into how to synchronize the images to and from a remote and central database as this is typically fairly straightforward when using a data synchronization technologies like MobiLink
Categories: 
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