.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

SQLMetal stops working (relations in SQL Compact)

Posted By:      Posted Date: September 13, 2010    Points: 0   Category :Sql Server
Hi!   I was trying to create a dbml file using SQLMetal, but it fails: the database is a SQL Compact 3.5 file, that contains several relations between it's tables. SQLMetal stops working without any error message. I have tried: SQLMetal.exe, SQLMetal Builder and SQLMetal OSUI. All fails on this db file, but runs fine on other .sdf files! When i remove the relations it creates the dbml file in a sec., without any problem!   Is it a bug, or it is not possible at all? If it is not possible, how should i solve this?   Thanks in advance!

View Complete Post

More Related Resource Links

Keyboard shortcuts stops working in WebMatrix


I'm often experiencing that keyboard shortcuts stops working in WebMatrix. This is very annoying as CTRL-S, CTRL-C, CTRL-V, etc. stops working, all of which are heavily used when programming. It's obviously hard to explain how to reproduce this, but I was wondering if someone knows a quick-fix?

Image stretch inside a grid stops working horizontally once columns are added to grid.

I have a simple setup of a window. Window contains a grid, inside the grid there is an image. I want the image to always stretch across the entire cell. I've set it's Stretch property to Fill and it works fine, as long there is only one column in the parent grid. As the window is resized, the image stretches correctly. As soon as I add another column, the image stops stretching horizontally. Vertially it works just like before, horizontally it now appears with a fixed width corresponding to the width of the picture used as the source. Does not matter which column it's positioned in, and I've tried encapsulating it into another grid but behaviour does not change. It behaves the same in both Visual studio 2010 designer and at runtime. In addition when I tried to encapsulate it in a second grid, this seond grid also now has altered behavior - instead of sizing itself to it's container (both height and width are not set) as it's parent grid does, it now sizes itself to its contents - the image. But only horizontally. What is going wrong here, is this a bug or am I missing something, and any advice on how I can get the image to fill one of the cells of a grid with more then one column?

Out-of-box filter stops working as soon as I "Configure Datasource"

I'm running VWD 2008 Express with ASP.NET 3.5 I realize now that 4 has much better filtering controls, but I didn't realize that when I started my project.  Anyway, when I use the standard List.aspx to display a table, the filtering works just fine (yes, it's only foreign keys and booleans, but it works).  I then modify the linq datasource so that the gridview only displays the columns that I want, and the filter function immediately stops working.  You can choose from the drop down lists, but nothing happens.  As an aside, I don't want to set scaffolding to false for those columns because I do want them to show up in the Edit.aspx page.  My understanding is that scaffolding settings would keep the field from showing up in either page. What do I need to include in either the gridview or the linqdatasource to get the filter working again?   Thanks!

After async postback, hide/show panel stops working

I have a Gridview in an UpdatePanel with a column containing an "expander" button that shows (and hides) more detail beneath its row of data.  It all works great until the user pages the gridview.  After the async postback to page the gridview, the javascript function to toggle hide/show appears to work flawlessly (the expander's button image even changes correctly), but the detail panel just doesn't show on the page.Note that my expander control supports a "AsyncTriggerId" property that, if set in the markup, will rebind the javascript toggle function when that control triggers an async postback (see OnPreRender below)Here's the hide/show toggle javascript:function toggleExpander(divId, imgId) { var div = document.getElementById(divId); var img = document.getElementById(imgId); var cssClass = div.getAttribute("className"); if (div.style.display == "" || div.style.display == "none" || cssClass == "hidden") { div.style.display = "inline"; div.setAttribute("className", ""); img.src = "images/dir_down.png"; mce_src = "images/dir_down.png"; img.alt = "Collapse to hide details"; } else { div.style.display = "none"; img.src = "images/dir_rig

Radiobuttonlist triggers updatepanel only a few times adn stops working


I have a radiobutton that triggers the updatepanel to display or not..

when the page loads, i can select yes adn it displays, i can select no and it disappears.. i hit yes it reappears.. but after like the 3rd time going back and fourth testing the functionality, it stops displaying all together.

Is there something i need to look at to find out what is going on?

Here is my code on the page and code behind

            <asp:UpdatePanel ID="UpdatePanel2" runat="server" UpdateMode="Conditional" >
            <div id="camDL" runat="server" visible="false">
                  CONTENT GOES HERE
                    <asp:AsyncPostBackTrigger ControlID="rblEnableCamDL" EventName="SelectedIndexChanged" />

        protected void rblEnableCamDL_SelectedIndexChanged(object sender, EventArgs e)
            if (rblEnableCamDL.SelectedValue == "1")
                camDL.Visible = true;
            if (rblEnableCamDL.SelectedValue == &qu

Sharepoint site randomly stops working


Hi.  We have a SPS 3.0 site running on Server 08 R2 which in turn runs on an ESX 4.0 host.  We have a mix of remote and local users and this issue only seems to apply to local users (Ones directly connected to our internal network).

What happens is randomly, they try to go to our Sharepoint site and they get a Website cannot be found error in IE.  If they leave it for a half hour or so it just starts working again.  It is a strange and annoying problem that we have been unable to solve so far.  There is nothing in the main event logs (ie. App, System, etc).  We get users to let us know as close to the minute as possible when the site stops working and we cannot locate anything at those times.

The Operating systems range from XP SP3 to Windows 7.  It also occurrs when using IE8 as well as several newer versions of Firefox.

We are still able to ping the internal IP of the site when this issue is occuring, but are not able to contact it via HTTPS.

Can anyone help us by giving us somewhere to start in troubleshooting this issue further?


Explorer View within Sharepoint 2007/IE7 stops working when activating an Office 2010 install.


Has anyone else experience this issue:

Office 2010 is installed on a machine with IE7 running on it.

Explorer view within Sharepoint 2007 and IE7 works fine

Office 2010 requires a product key change from a temporary key from the initial install to a permenant key.

The permenant key is installed and suddenly Explorer view within Shrepoint stops working?

Ajax enabled WCF Service stops working with Undefined error


 I have an Ajax Enabled WCF service that I call from Javascript.  It works fine, but often after I make unrelated changes to the website it will fail and Javascript will report an 'Undefined' error.  I can easily fix it by deleting the service, removing the system.serviceModel section of the Web.config and then recreating the service.  I don't have to change any of the references in the .aspx or .js files.  Also, the replacement service has identical code in the .config, .cs and .svc files (I don't see any differences).  This morning, I only made some cosmetic changes and the service stopped working again. 

Any insight into what I am doing wrong?

Visual Studio - Debugging Stops Working


We keep having problems with the Visual Studio debugger (2005 and 2010).

It just stops hitting breakpoints and the only way to fix the problem is to close every open VS instance.

After all instances are closed, we can open a project in Visual Studio and the debugging breakpoints work again.

Any comments would be appreciated. 

SQL Server Compact v3.5 SqlCeEngine.Upgrade method not working on PocketPC 2003/Windows Mobile 2003

When trying to use the SqlCeEngine.Upgrade(string connectionString) method i get the following exception:

The Parameter is incorrect.
at System.Data.SqlServerCe.SqlCeEngine.ProcessResults()
at System.Data.SqlServerCe.SqlCeEngine.Repair()
at System.Data.SqlServerCe.SqlCeEngine.Upgrade()
at Vbi.Compact.ErbisPda.Client.Program.Main()

The same code works like a charm on a Windows Mobile 2005 device. I installed "SQL Server Compact v3.5 Core" and "SQL Server Compact v3.5 Repl" on both devices, the WCE4/Armv4 version on Pocket PC 2003 and the WCE5/Armv4i version on Windows Mobile 2005.

I am hoping someone can help me with this problem, its being a showstopper.

[edit]Please note that i am using v3.5 and not v3.5 SP1. This is because for some of our data access we use a 3rd party library that needs v3.5 without SP1. Also i didn't run across above problem when i deployed my application from Visual Studio 2008 SP1 (debugging), it does occur on a clean system with only the two mentioned SQL Server Compact cabs installed and our app.[/edit]

openrowset Microsoft.ACE.OLEDB.12.0 stops working after some days



I'm using Microsoft.ACE.OLEDB.12.0, in SQL Server 2005, to read and write, using openrowset, data from/to access files.

Everything works fine for some time but then just stop works. After this, i can't do nothing with openrowset. If i make a select * from openrowset the server doesn't stop executing.

My Microsoft.ACE.OLEDB.12.0 configurations are:



exec sp_configure 'show advanced options', 1



exec sp_configure 'Ad Hoc Distributed Queries', 1



EXEC master.dbo.sp_MSset_oledb_prop N'Microsoft.ACE.OLEDB.12.0', N'AllowInProcess', 1


EXEC master.dbo.sp_MSset_oledb_prop N'Microsoft.ACE.OLEDB.12.0', N'DynamicParameters', 1


EXEC master.dbo.sp_MSset_oledb_prop N'Microsoft.ACE.OLEDB.12.0'

ASP.NET VB Syntax Highlighting Stops Working


Normally in Visual Web Developer Express 2010 syntax highlighting for my VB code will stop working when there is an error in the page right before the code. Lately I've had the problem that all VB code in an entire website will start doing this with no errors in the page/code.

It's impossible to debug without syntax highlighting and quite a bit harder just to write new code. The last time I this happened I did as follows.
- Successfully tried opening the website on a different computer in VWD Express
- Closed the website and reopened with no change
- Closed VWD and reopened with no change
- Built the website with no change
- Reinstalling VWD Express with no change

Finally I had to reimage my entire computer and reinstall VWD which worked for less than 2 weeks before the problem returned. This has to be a known issue but the search on this forum appears to be down. I can't reimage my PC every 2 weeks, does anyone have suggestions? 

Keyboard shortcuts stops working in WebMatrix


I'm often experiencing that keyboard shortcuts stops working in WebMatrix. This is very annoying as CTRL-S, CTRL-C, CTRL-V, etc. stops working, all of which are heavily used when programming. It's obviously hard to explain how to reproduce this, but I was wondering if someone knows a quick-fix?

Working with SharePoint document libraries

Document libraries are collections of files that you can share with team members on a Web based on Microsoft Windows SharePoint Services. For example, you can create a library of common documents for a project, and team members can use their Web browsers to find the files, read them, and make comments. Users with Microsoft Office 2003 can check out and edit the files as if they resided on a local or network drive.

By default, your team Web site comes with a built-in document library named Shared Documents, which is listed on the Quick Launch bar as well as on the Documents and Lists page.

Working with DropDownList and ListBox Controls in ASP.NET

"In my application i am using dropdownlist to display all categories from a table. When the user clicks this control I display all records in that category. Category table also contains column called color.

I wanted display some categories in dropdown list different color and others in different color using ASP.NET."-Anonymous

Bar Code Scanners with the .NET Compact Framework

Summary: Learn how to make your applications use bar code scanners in a generic way-ndependent of the specific bar code scanners that are used on different devices. Using the design patterns Façade and Factory, the implementation not only supports multiple bar code scanners, but it also makes it easy to add support for other bar code scanners. After a brief discussion about bar code scanners and the bar code scanner pattern, a download code sample, written in C#, demonstrates the use of the pattern and technologies.

Serial Communication with the .NET Compact Framework

Learn how to make your applications communicate over a serial port and how to handle common issues when implementing serial solutions. After a general discussion about serial communication and a common serial communication standard, this article demonstrates a practical use of the technologies through sample source code written in C#.
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