C# - Catch SqlException When Attempting NHibernate Transaction?
Mar 22, 2011
I need to see an errorcode produced by a SqlException - however, I can't get one to fire. I use NHibernate and have a SQL UNIQUE CONSTRAINT setup on my table. When that constraint is violated, I need to catch the error code and produce a user-friendly message based off of that. Here is a sample of my try/catch:
using (var txn = NHibernateSession.Current.BeginTransaction()) {
try {
Session["Report"] = report;
_reportRepository.SaveOrUpdate(report);
txn.Commit();
[Code]....
View 2 Replies
Similar Messages:
Apr 5, 2010
I am writing a simple ASP.NET MVC using session per request and transaction per request patterns (custom HttpModule).It seems to work properly, but.. the performance is terrible (a simple page loads ~7 seconds). For every http request, graphical resources incuding (all images on the site) a transaction is created and that seems to delay the loading times (without the transactions loading times per one image are ~1-10 ms with transactions they are over 1 second).What is the proper way to manage transactions in ASP.NET MVC + NH stack?
When i've put all transactions into my repository methods, for some obscure reasons I got 'implicit transactions' warning in NHProf (the SQL statements were executed outside transaction, even that in code session.Save()/Update()/etc methods were invoked within transaction 'using' scope and before transaction.Commit() call) BTW are implicit transactions really bad?
View 3 Replies
Aug 16, 2010
I've been stuck with this for days, and posted elsewhere online without success. If anyone can provide me with an answer to this problem I will arrange for beer to be sent to your chosen address....I have a DataTable containing multiple rows of data that I want to insert into a SQL 2005 table. The code works perfectly when the DataTable contains values that meet the SQL table schema design (e.g. all rows have a username, password, firstname & surname). However, when a value is missing or incorrectly entered (e.g. no firstname value), this causes a SqlException. I need to handle this in ASP.NET to provide a more user-friendly error message than what SQL gives, then rollback the whole transaction to cancel the transaction.The code attached is an imitation of how my data layer works. The error occurs on the
RollBack() method. The error is: 'Object reference not set to an instance of an object'Can anyone explain why this happens? The SqlCommand object seems okay when I debug (it exists), but the
Transaction object is lost as soon as the SqlException occurs. Although the transaction never commits when a SqlException is thrown, its a pretty ugly exit.My code design might be poor, in which I would welcome advice, but most important I need to figure out how to trap SqlExceptions without this error occuring, and Rollback as needed.The SqlException Numbers thrown are 2601 or 2627, both of which carry a severity level of
14, which is not high enough for the SqlCommand object to close the connection according to MSDN.The code looks lengthy but should be simple to follow...
[Code]....
View 1 Replies
Jun 15, 2010
I've got all of my ASP.NET requests wrapped in a Session and a Transaction that gets commited only at the very end of the request. At some point during execution of the request, I would like to insert an object and make it visible to other potential threads - i.e. split the insertion into a new transaction, commit that transaction, and move on. The reason is that the request in question hits an API that then chain hits another one of my pages (near-synchronously) to let me know that it processed, and thus double submits a transaction record, because the original request had not yet finished, and thus not committed the transaction record.
So I've tried wrapping the insertion code with a new SessionScope, TransactionScope(TransactionMode.New), combination of both, flushing everything manually, etc. However, when I call Refresh on the object I'm still getting the old object state. Here's some code sample for what I'm seeing:
Post outsidePost = Post.Find(id); // status of this post is Status.Old
using (TransactionScope transaction = new TransactionScope(TransactionMode.New))
{
Post p = Post.Find(id);
p.Status = Status.New; // new status set here
p.Update();
SessionScope.Current.Flush();
transaction.Flush();
transaction.VoteCommit();
}
outsidePost.Refresh();
// refresh doesn't get the new status, status is still Status.Old
View 1 Replies
Feb 7, 2010
Here is the code copied from [URL] In asp.net code behind, I use try-catch try to catch any error but never catch it. In SQL database, if I rename Employees to Employeesx or change column DepartmentID to DepartmentIDx, record will not be deleted (it is right) without any error (it is wrong, suppose catch an error).
CREATE PROCEDURE DeleteDepartment
(
@DepartmentID int
)
AS
BEGIN TRANSACTION
DELETE FROM Employees
WHERE DepartmentID = @DepartmentID
IF @@ERROR <> 0
BEGIN
ROLLBACK
RAISERROR ('Error', 16, 1)
RETURN
END
DELETE FROM Departments
WHERE DepartmentID = @DepartmentID
IF @@ERROR <> 0
BEGIN
ROLLBACK
RAISERROR ('Error', 16, 1)
RETURN
END
OMMIT
View 2 Replies
Sep 14, 2011
I get this error in the browser:
Code:
Thread was being aborted.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.Threading.ThreadAbortException: Thread was being aborted.
Source Error:
An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.
Stack Trace:
[ThreadAbortException: Thread was being aborted.]
System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) +486
System.Web.ApplicationStepManager.ResumeSteps(Exception error) +501
System.Web.HttpApplication.System.Web.IHttpAsyncHandler.BeginProcessRequest(HttpContext context, AsyncCallback cb, Object extraData) +123
System.Web.HttpRuntime.ProcessRequestInternal(HttpWorkerRequest wr) +379
Version Information: Microsoft .NET Framework Version:2.0.50727.3053; ASP.NET Version:2.0.50727.3053
I have try{}catch(Exception ex){} in the right place:
Code:
protected void Button1_Click(object sender, EventArgs e)
{
try
{
// all processing occurs inside here
}
catch(Exception ex)
{
}
}
I even created a global.asax file and on the Application_Error event, I wrote a code that would email me the error (and i'm not getting an email regarding that error when I get the error shown above). I know for a fact that the thread is going inside the "try" statement because I send emails to myself whenever it finishes certain codes inside of it. So how come I'm getting that error in my browser instead of it being handled in my "catch" statement? I have two problems here, one, why is the exception not going to my "catch" statement, and two, why am I getting that error in the first place.
Note: my web app calls a webservice.
View 2 Replies
Sep 22, 2010
I have a large asp.net project to which I want to add MVC functionality. I have added the necessary references into the project (System.Web.Mvc (v 2.0), System.Web.Abstractions (v 3.5) and System.Web.Routing (v 3.5) and amended all the required files (Global.asax (routing requirements), the web.config, project (Controllers and View folders) and created a basic HomeController and ViewPage.
When I run the application and attempt to go to the controller via {serverpath}Home I am getting the error "An unhandled exception has occurred - Could not load file or assembly 'System.Web' or one of its dependencies. The system cannot find the file specified." I've tried browsing the net but the error is too vague; is there a good way to identify exactly why the assembly cannot load?
View 1 Replies
Dec 29, 2010
I want to execute a SQL query inside EF [Code]....but I got an error
Exception Details: System.Data.SqlClient.SqlException: Incorrect syntax near 'orderby'.
I try running my query in the SQL Server, such as :
select * from Airplane A inner join Flight f
on A.ID = f.Airplane_ID where FromSrc = 1 and ToDest = 3
order by Price, Comfort, Timeliness, [Safety] desc
it works fine.
View 2 Replies
Jan 25, 2010
I have been trying to figure this out and can't... I have seen this code used before but for some reason it will not work in this situation. I have a GridView and I want to truncate cells where the field length is greater than 18 characters and then show the entire contents in a tool tip. The tool tip works fine but I can't get the field contents to truncate. When I run in debugger the tc.text always shows as . but when the page renders there is content in these cells, content over 18 characters. The code never errors out it just never sees the contents as anything but "" and therefore never truncates the field contents.
[Code]....
View 5 Replies
Oct 2, 2010
I get "Endpoint not found" when attempting to access my service via the browser at
[URL]
I get "Error: Cannot obtain Metadata from http://localhost:10093/Services/Service1.svc" when attempting to access the same address from the wcftestclient.
If I place a breakpoint in the service implementation it is hit, so I assume the svc file is setup correctly:
<%@ ServiceHost Language="C#" Debug="true"
Service="MyApp.Core.Service.Service.MyAppService,MyApp.Core.Service"
Factory="CommonServiceFactory.WebServiceHostFactory,CommonServiceFactory" %>
Here is my config:
[code]....
View 3 Replies
Dec 26, 2010
First, I am new to VWD 2010 and attempting to create a data driven website.
I am attempting to return a value from an sql server stored procedure and store that value in a variable. I have searched here and online and tried to follow the examples that I found. However, I have not been successful in making it work.
Here is my stored procedure:
[Code]....
Here is my VB code behind where I am attempting to get the return value:
[Code]....
I know that I have a good connection because I am using the same connection string from my WebConfig file and it is working in other instances.
Below is the error message that is being displayed.
'The formal parameter "@monRegAmt" was not declared as an OUTPUT parameter, but the actual parameter passed in requested output."
View 11 Replies
Jan 17, 2010
I am having an issue when attempting to override the DisplayNameAttribute in ASP.NET MVC to provide a localized string. The code itself is straightforward and similar to that in another Stackoverflow post link text
The code works for global resources but not so well for local resources. I have a registration screen and used the Visual Studio "Generate Local Resource" command to create my local resource file. The generated file is named Registration.aspx.resx and the App_LocalResources folder is created relative to the actual Registration.aspx page - as one would expect.
However, when I attempt to get the localized string using:
ResourceManager.GetString(resourceKey)
I receive the following error message.
Could not find any resources
appropriate for the specified culture
or the neutral culture. Make sure
"FullAssemblyName.Views.Account.App_LocalResources.Registration_aspx.resources"
was correctly embedded or linked into
assembly "FullAssemblyName" at compile
time, or that all the satellite
assemblies required are loadable and
fully signed.
Using reflector, I can see that the file is actually Registration.aspx.resources and not Registration_aspx.resources - the underscore/period being the subtle difference
FullAssemblyName.Views.Account.App_LocalResources.Registration.aspx.resources
I have toyed with the code quite a bit but no matter what I do, the file being requested is always different than that copiled in the assembly. For instance, if i rename Registration_aspx (in the generated Registration.aspx.designer.cs class i get the same error but this time the path is "...App_LocalResources.Registrationaspx.resources"
Has anyone run into this? Is there any way I can ensure that the resource found in my assembly has this underscore?
View 1 Replies
Feb 2, 2011
I currently have this controller function:
public ViewResult Edit(int id)
{
//get user from id
var user = _adminRepository.GetUser(id);
return View(user);
}
This currently gives me an error on my view page if I attempt to edit an item with an id of 100, when there is no user with an id of 100 in the database. What's the best practice for handling this? Send them to a Create page, or show a friendly error message? Should that redirect functionality be within the controller function?
View 4 Replies
Sep 15, 2010
Attempting to use any of the control toolkit is failing for me. It seems to be failing on the official site, as well. All of the examples are broken, with a javascript error on the page. Here is an example:[URL]
View 8 Replies
Feb 17, 2010
Suppose I have a user table that creates strong relationships (Enforce Foreign Key Constraint) with many additional tables. Such orders table ..If we try to delete a user with some orders then SqlException will arise.. How can I catch this exception and treat it properly?Is this strategy at all?1) first try the delete action if an exception Occur handel it?2) Or maybe before the delete action using code adapted to ensure that offspring records throughout the database and alert according to .. This piece of work So how to do it?
--Edit:The goal is not to delete the records from the db! the goal is to inform the user that this record has referencing records. do i need to let sql to execute the delete command and try to catch SqlException? And if so, how to detect that is REFERENCE constraint SqlException?Or - should I need to write some code that will detect if there are referencing records before the delete command. The last approach give me more but its a lot of pain to implement this kind of verification to each entity..
View 1 Replies
Aug 11, 2010
I have this piece of code for a mailing list signup control.
[Code]....
How can I modify this so I can use a path to a new image for the button.
View 2 Replies
Mar 16, 2010
After I installed the .net framework 3.5 to my iis box (which didn't have any previous version of .net fraemwork), I'm not long able to upload the aspx page via WebDav with MS Expression Web. I got the "HTTP/1.1 403 Forbidden " error message.
Also I got this error "Server Application Unavailable" when trying to open the aspx page. my iis box is not a domain controller nor a backup domain controller.
I have enabled the webservices extention - "ASP.NET v2.0.50727" and "WebDAV";
View 1 Replies
Feb 1, 2011
I am attemting to remote debug my application in a outside server I have the IP and the the user. I am using in my server msvsmom.exe 64bit version 10.3.30319.1. In my computer I have visual studio 2010. I had opened all the port required in the MSDN docimentation in the server and host. I copied my web application in the server.
When I am trying to connect from my VS2010 in "Attach to Process" using in qualifiers this format with the real information : Administrator@xxx.xxx.xxx.xxx
I have this error: "Unable to connect to the Microsoft Visual Studio Remote Debugging Monitor named Administrator@xxx.xxx.xxx.xxx" The visual Studio Remote Debugger does not support this edition of windows"
View 2 Replies
Jan 22, 2010
i m using VSS 2005 and VS 2005. on one machine i installed VSS 2005 and create project. on second machine i opended my project using project source safe, it ask me for user detail and i enter details. i got the complete project. problem is that when i try to run project i got following error. "An editor or project is attempting to check out a file that is modified in memory, which will result in saving it. Saving files during the build process is dangerous and can result in incorrect build outputs in future. Do you want to continue with the check out?"
View 1 Replies
Jul 23, 2010
I've been able to create it. Now I'm confused where to the type from in the video at 21.39
This is the video:http://www.asp.net/general/videos/how-do-i-create-a-custom-membership-provider
View 4 Replies
May 21, 2010
I use a dbml for my Data Access Layer to provide the data that i need in my app. When i connect from the server explorer everything seems fine. I choose to use my windows authentication and the connection test shows everything works just fine. When i Build my solution and run it on my IIS it says that i'm using a login that is not working.
View 3 Replies
Mar 16, 2010
I am attempting to add a drop down menu to a gridview once the user slects the "Edit" button for the gridview. I want the value, before the edit button is selected, to be the value in one table and once the "Edit" button is selected I want to show values from another table in a drop down menu so the user only has specific values to edit the selected row with.
2 tables:
table 1) tbl_FormalizeRawData - List of columns from a table inside a database
table 2) tbl_StandardColumns - list of standard column names for system tables.
I want the user to be able to specify which raw non standard columns corospond to the standardized system table columns.
example:
RawClientTable.MiscColumn1 = SystemTable.Member_First_Name
RawClientTable.MiscColumn2 = SystemTable.Member_Last_Name
my code for the gridview is as follows. I am looking to see what else I need to do in order to allow the gridview to be edited on the final column by a dropdown menu populated by a seperate table but display the item in the main table with all the non standard column names:
[Code]....
a boot in the rright direction. I attempted to go through the "Walkthrough: Displaying a Drop-Down List While Editing in the GridView Web Server Control" at the website[URL] as it was geared toward a drop down menu added to a gridview both using the same table.
View 1 Replies
Jun 9, 2010
We are seeing the following timeout error being logged into our Event Viewer every now and then. We are using LINQ to connect to the SQL Server 2008 and the connection string is defined in the web.config file.One wierd thing I noticed is that the .NET framework is timing out trying to detect if this is SqlCe connection string. Why is it trying to waste time and then timing out when we have a SQL Server 2008 as the database?
What can I do to fix this problem?
Server: Windows 2008 R2 64-Bit
\IIS 7.5.7600.16385 Application Pool: Integrated Mode with 32-Bit Applications Enabled. Queue Length = 5000, Indentity = Network Service.Database Server: SQL Server 2008
[code]...
View 2 Replies
Jan 22, 2010
I have a straight forward SP that throws a divide by zero error like:
[Code]....
Note that even though I am calling RAISEERROR() its not getting returned back to my code if I use this try catch. When I remove the try catch like above it returns fine. I made sure that the severity level is >= 11 so it's not ignored. At this point I'm out of ideas because everything I can find published seems to say that this should work.
FYI my C# code is pretty straight forward I don't think it has anything to do with it as I have a wide open Exception catch and it's never getting called so I'm not posting it to keep this message brief.
View 3 Replies
Mar 22, 2010
[Code]....
View 5 Replies
