.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

Refresh dbml when Stores Procedurs are Changed in database

Posted By:      Posted Date: October 14, 2010    Points: 0   Category :ASP.Net


I have a DBML file in C#. And I have drag and drop some Stored Procedurs in it . Now I have changed some SPs. Now I want to refresh the dbml file without drap and drop the SPs. How can I do it in C#. Is there any way that the changes Made in SPs will come with out drag ang drop the SPs.

View Complete Post

More Related Resource Links

Refresh dbml when database schema changes



 I have a .dbml file that I have dragged several tables on to from a database in the Server Explorer.  I have written a lot of code against the model that was created.

Now I have added another table (Companies) to the database and a Foreign Key in one of my existing tables (People) which references the PK of the new table.  I have refreshed the Server Explorer and can see the new table and the new FK in my existing table.  I can drag the new table on to the dbml workspace, no problem.  But how do I make the new FK appear in the dbml class?  I have tried right-clicking on the .dbml file in the Solution Explorer and choosing "Run Custom Tool" but that doesn't do anything.  I suppose I could just delete the .dbml file and start all over again, but surely there is a better way!  Eventually there will be dozens of tables involved and recreating every time one column changes in one table would be very painful.

Please tell me that I am overlooking something simple.

As a matter of interest, what if I went the other way and added or modifed a class in the dbml, can I get the database schema updated?

thanks in advance


SQLCMD: supress "Changed database context to . . ."

Product:  2008 SQL Server Standard Edition. Shell:     SQLCMD (i.e. sqlcmd -i"test.sql")Script (test.sql):   use Master;   print $(SQLCMDERRORLEVEL)The screen output is always:   Changed database context to 'Master'   0However I want the above output to be (only):   0I have tried calling SQLCMD with the -m command line parameter set to each of the {-m-1, -m 0, -m 1} settings, but none work. I have tried: set SQLCMDERRORLEVEL = each of {-1,0,1,25), but none workAnybody know the secret?Thanks in advance,Jerry

SQLCMD: Changed Database Context messages

Is there a way to suppress the "Changed Database Context to " messages in SQLCMD?  For example, I get the following: 1> use master2> goChanged database context to 'master'.1>I am trying to migrate some legacy batch files that called isql and used the output files.  These extra "Changed Database Context to " messages are causing our scripts to break, and I was hoping to avoid having to write something extra to handle these messages.Thanks.

database refresh time

Hi,we have a sql server 2005...that has 70-80 databases and hundreds of tables....It is supposed to refresh every night.... refresh is done by other vendor(3rd party).... we dont know what method(technology) they use to refresh the databases....My question is .....Is there a good way to know when the last refresh has happend...can we determine it from sys tables.....the sql server is installed in window server 2003 box.... we have access to the box as well as the sql server.....plz suggest...

Refresh update panel when database changes

I have an admin page in which I need to change the list whenever a user signs up on our web site.How can I put and event to MySql database so that whenever the count of  a table row changes it refreshes my update panel for me to see the new user.

Any negative impact to Sharepoint and Project Server if IP for backend database server is changed.


If IP address of the backend database server will be changed for sharepoint 2007 and project server 2007, will it impact any way  both the servers.

How to judge changed data and update data in database


For my case, I use linq to sql to select data from database.

I want to do the edit fuction which has 3 steps.

1. load all the data first

2. enter the button then save changed content not all to database.

I am totally new to asp.net. Could someone tell me that how to save only changed data using linq?


Thank you






Is a database online when it is changed from full to simple recovery model?



We have some databases that occaisally have very large ldf files and I have learned that the best way to shrink the ldf file is to change the backup mode to simple, shrink the log file, convert it back to full and do a full database backup so that the log file backups will run again. My question is during this process is the database available to the end users? When you guys do this do you feel it is nessesary to let the end users know or will they not notice what is going on?



Thanks! Kevin

Retrieving changed/updated data from all tables in database



I'm looking for some advise on how I could solve the problem I face, I have various instances of sqlexpress 2005 in different remote locations which are not accessible via internet vpn etc as they are all in corporate networks that will not allow access. What I think I need to do is create some sort of process/service that can be installed on the client and run at a set time/date that collects all the data from theses instances and then push the changes to our remote instance of sql server. Can anyone possibly point me in the right direction of various technologies I should be looking into to solve this problem. All clients would be running windows XP. I have been searching for a few day's but I can't find anything to get me going. If this is not the right forum for this type of question can you suggest any?


Thank you.

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.
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