Database Connection in Asp.net using Razor

Sadaqat Jeelani

10y2.6k.NET

Hi!

Here is My code i'm on entry level facing problem working on database in asp.net razor

@{
var db = Database.Open("SmallBakery");
var selectQueryString = "SELECT * FROM Product ORDER BY Name";
}

Small Bakery Products

@foreach(var row in db.Query(selectQueryString))
{

}

Id	Product	Description	Price
@row.Id	@row.Name	@row.Description	@row.Price

When i run this code it's showing me an exception and that exception is (SqlException unhandle by user) please help me

4 Replies

Know the answer? Post it — somebody with the same question will find it here.

Sadaqat Jeelani10y ago
Here is detail of exception

An exception of type 'System.Data.SqlClient.SqlException' occurred in System.Data.dll but was not handled in user code
Additional information: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL
Afzaal Ahmad Zeeshan10y ago
@Raja T

I think Sadaqat here, is using the ASP.NET template of Bakery. In it, they used SQL Server CE databases, which do not require you to install an instance of SQL Server. SQL Server CE are no longer supported and WebMatrix (the tool which excels in SQL Server CE and ASP.NET Web Pages) is also no longer maintained by Microsoft. SQL Server CE is an embedded database, read more here: https://msdn.microsoft.com/en-us/data/ff687142.aspx

But I do agree on your claim of "being unable to open a connection". I am still waiting for the error message to share any legit reason behind this error.
Raja T10y ago
Hi,
It seems that you are not able to connect to sql server instance. Better use exception handling mechanisms to tackle this problem.
Please check...
1. Verify the name of SQL server instance
2. Verify Whether the SQL server instance you are trying to connect is up & running
3. Verify the username is correct.
4. Verify the password is corerct.

Exception will be occuring when you are trying to open connection.

more details check out below links

http://www.codeproject.com/Questions/374286/Error-SqlException-ubhandled-by-user-code

http://forums.asp.net/t/1311394.aspx?SqlException+was+unhandled+by+user+code
Afzaal Ahmad Zeeshan10y ago
As far as I can see the error would be if the database doesn't exist. Check your web.config and see if you have a database connection; in most cases it should be there as this is a template you are using.

But that was just a guess, please share the exception details. "SqlException unhandled by user..." doesn't share much details about the error. :-) What is the description?