ADO.NET :: How To Avoid DuplicateKeyException When Using Context.ExecuteCommand

Nov 27, 2010

I have a project with linq2sql and need to execute sql string directly in some situation.

But I found the submitchange method will throw DuplicateException when using ExecuteCommand and InsertOnSummit() alternately.

The code below works correctly

[Code]....

[Code]....

View 1 Replies


Similar Messages:

HttpHandlers / Modules :: Context.Response.Output Vs Context.Response.Write()?

Jan 24, 2010

I have written simple HttpModule. context.Response.Output.Write is working fine. but not context.Response.Write().

View 2 Replies

Entity Framework 4 - Extending Context Of One Edmx File To A Context Of Another Edmx File?

Oct 14, 2010

My Question is can we extend one context to another in Entity Framework 4. Following is the problem background.

I am using EF4 for developing a Web-Application. My Web Application has 3 projects.

One project is for storing candidate CV information.

Another project is for storing customer information.

Final project is called CORE. this CORE contains a edmx file that should be extended by CV and CRM.

As an example email address table can be shared by both customer (CRM) and CV. To share one table with another, we should be able to extend one context (CV context) with other context (customer context). Could some one having experience using Entity Framework share your experience with me to find whether this is possible.

We have 3 edmx files in three class libraries:

Person class library(Core) with core.edmx-Basic details related to a person(name, email) CV Class library with CV.edmx wich have CV related data(Experiance,skills) Customer Relationship management system(CRM) which have customer data(sales data...)

Then we want to use core class library edmx file(Core.edmx) with cv.edmx (basically cv tables should be able to use tables from core tables) . Same way we want to use the core.edmx with CRM.edmx for the 3 rd project

View 1 Replies

How To Avoid XSS Vulnerabilities In MVC

Jul 8, 2010

I recently noticed that I had a big hole in my application because I had done something like:

<input type="text" value="<%= value%>" />

I know that I should have used Html.Encode, but is there any way to do that for all values, without having to do it explicitly?

View 3 Replies

Context Is Not The Member Of Error?

Nov 5, 2010

I have my website without layers now i am converting code to layers.

When i add some page design and try to generate its designer file be cliking rite on that page and clik on option

"Covert to web application" it gives me error namespace cannot have space and sometimes it gives me error

System.exception was thrown error

My codefile name is correct and inherit name also correct like below

Source code is

<%@
Page
Language="VB"
AutoEventWireup="false"
StylesheetTheme="SkinFile"
CodeFile="Managewebsiteusers.aspx.vb"
Inherits="admin_Managewebsiteusers " %>

My page name is ManageWebSiteUsers and it is in admin folder

class file name is

Partial
Class admin_Managewebsiteusers
Inherits BasePage

View 3 Replies

ADO.NET :: Cmd Does Not Exist In Current Context?

Nov 3, 2010

I am having a problem and yes I don't know what I am doing :)I need to have a calendar control or really any control i use set a parm to the selected or entered value. I have done some reading and I thought I found the answer but I am getting cmd does not exist in current context asp.net

[Code]....

View 1 Replies

ADO.NET :: Best Practices Of Using Data Context?

Feb 7, 2011

Here is the code of my Repository class:You see, I use singleton here. Also you see, there is a data context as class variable of Repository class.The main reason to use singleton here is a wish to avoid using 'using(NorthwindEntities context = new NorthwindEntities())' in every function.

[Code]....

This Repository is used in ASP.NET application. So only instance of NorthwindEntities (context) is used everywhere and that's why I never dispose it.So my question is: Won't this code cause connections to the DB that are not closed?

View 11 Replies

.net - Using AOP In Web Context And Affection On Performance?

Sep 18, 2010

I have a web application running most of my services through web services.
first i want to know how much degradation in performance would take place using AOP in web context for example if i can handle 200 request/second without AOP, what would be the result with it (having simple logging and authorization)

Is there any great AOP framework available out there for .NET ? Is it a better idea to use Proxy web services (implementing authorization, logging , ... in proxy) for gaining the better performance or the overhead of using AOP is negligible and its advantages worth performance degradation.

WHATS the best replacement for AOP in .net framework ?

View 1 Replies

Avoid Reload Window In Xml?

Aug 19, 2010

i need a information of how to avoid the reload source editor window for after xml file save using Asp.net

View 1 Replies

ADO.NET :: How To Avoid Identity_insert To Set Max Value As Identity

Jan 18, 2011

im using sql server 2008

as per microsoft, [URL]

when i execute the following

set identity_insert on
//insert statements here

set identity_insert off

the identity of the column is set to the maximum value. can i aviod this.

consider the following scenario,

my table has 2 rows as follows

id, name comm
1, John, 232.43
2, Alex, 353.52

now using the above code, when i insert
10, Smith, 334.23

as per the above link, sql server automatically sets the identity to 10. so for newly inserted records(without using identity_insert on), id automatically starts with 11.

i want the identity value to be 3, after using identity_insert on/off

View 7 Replies

How To Avoid Form Resubmission

Sep 21, 2010

I'm developing ASP.NET applications and stuck with a "problem" relating to resubmit behaviour. I'm controling the re-submit using a counter in form submit event which disables the submit if it's already been posted. My application is a 3 step workflow and when the 3rd step is shown the transaction was submited from step2 to step 3. What's my problem? Well... i want to avoid the user to resubmit the data by pressing the F5 or all other possibility. I don't want to disable the key because may be workarounds. I'm wondering if i can remove the post data in a HTTP module that runs after the render was completed and right before the response is sent to the user.

View 2 Replies

SQL Server :: How To Avoid Using Subqueries

Dec 23, 2010

How can I avoid using subqueries and still be able to select the same results in a query like this;

[Code]....

View 9 Replies

C# - How To Avoid The Extra Backslash

Dec 10, 2010

I'm have a page which I sent a parameter through the query string.

If I'm retrieving it with Request.QueryString["Format"] I'm having troubles with the type 'CDDVD'. It's being returned as 'CD\DVD'. It's important I get this as the right string.

How do I avoid the extra backslash? Or even get rid of it later?

View 2 Replies

How To Avoid Duplication In Combo Box

Jan 10, 2011

I have used the database data to combo box values. But the problem is i don't now how to avoid the duplicate data. for e.g In a single column name called "department " is used so many time but i wanted it only one time should be displayed the combo box.

View 5 Replies

Can Avoid Duplicates From Array (in C#)

Feb 15, 2010

i want to avoid duplicate entries from array.....(in c#)

View 2 Replies

C# - Avoid An HttpException Due To Timeout?

Apr 26, 2010

I'm working on a website powered by .NET asp/C# code. The clients require that sessions have a 25 minute timeout. However, sometimes the site is used, and a user stays connected for long periods of time (longer than 25 mins). Session_End is triggered:

protected void Session_End(Object sender, EventArgs e)
{
Hashtable trackingInformaiton = (Hashtable)Application["trackingInformation"];
trackingInformaiton.Remove(Session["trackingID"]);
}

The user returns some time later, but when they interact with the website, they get an error, and we get this email notification:

User: Unauthenticated User
Error: System.Web.HttpException

Description: Failed to load viewstate. The control tree into which viewstate is being loaded must match the control tree that was used to save viewstate during the previous request...

The telling part of the stack trace is System.Web.UI.Control.AddedControl. Apparently, the server has thrown away the session data, and is sending new data, but the client is trying to deal with old data. Hence the error that "the control tree into which viewstate is being loaded [doesn't] match the control tree that was used to save the viewstate during the prevoius request."

So here's the question. How can I force instruct the user's browser to redirect to a "you're logged out" screen when the connection times out? (Is it something I should add to the Session_End method?)

View 3 Replies

C# - Avoid Paging On GridView?

Mar 4, 2010

protected void Button3_Click(object sender, EventArgs e) //export
{
GridView2.AllowPaging = false;
GridViewExportUtil.Export("Сводка.xls", this.GridView2);
GridView2.AllowPaging = true;
}

I need to avoid pageing for XLS export :-/

View 1 Replies

VS 2008 - Data Context Is Not Defined?

Oct 8, 2010

Error3Type 'LinqChatDataContext' is not defined.

i have above error whne woring with linq

View 3 Replies

Set A Coding Namespace For Both The Context As Well As The Entities?

Apr 15, 2010

I typically don't play with betas, so I am just now getting used to vs 2010 pro. I grabbed it from DreamSpark yesterday, and so far I like all the changes.

I was wondering though, with some of the changes to ado.net EF, is there now a way to set a coding namespace for both the context as well as the entities, instead of just setting the custom tool namespace (this wraps both context and entities)? Typically, I like having my classes grouped into namespaces by type, and since a context isn't an entity, it shouldn't go in the entities namespace. note: I am talking about actual coding namespaces, not the conceptual namepsaces used internally by EF.

I was also wondering if having this (the x86 vs 2010 ide) beside my old one (x64 vs 20080 ide) would pose any problems? It seems to be working ok, I just wanted to make sure I hadn't missed announcements saying I had to de-install one before installing the other.

View 2 Replies

MVC :: Getting Server Context In Global.asax.cs?

Apr 19, 2010

I'm using the HttpRunTime.Cache.Add to create a routine that runs every 5 mins to post data out of my app to the main DB, and this works fine. However I also need to import some files from disk in this routine. I have my document directory set up in my web.config as a ~/ relative path and resolve this in normal controller actions using Server.MapPath(string). How can I do this in my Global.asax.cs code -when I try to access it, it throws an error?

View 3 Replies

Call A WCF Service Outside Of The Impersonation Context?

Jul 30, 2010

I'm having problems with impersonation in WCF. Namely, I'm calling a named pipe service from within ASP.NET with impersonation turned on. This fails (due to permissions on the pipe blocking anyone from the network). So, is there any way I can make the call outside of the impersonation context? I don't need to be impersonating to make this call, but can't see any way of doing this.

PS. I need to do this declaratively, through config...

View 1 Replies

MVC :: Loading Controllers From WebService Context

Dec 30, 2010

I'm using the release 1 candidate from a few weeks ago and am loading my controllers from the spring.net context. I notice that my factory which couldn't be simpler keeps being called for a controller called "css". I'm using the Razor template engine. Does mvc or razor create any behind the scenes controllers that I don't know about?

View 2 Replies

SQL Server :: Subqueries Are Not Allowed In This Context?

Dec 6, 2010

When i am executing following query:

INSERT INTO Customer (ID, FullName, WebSite, AnnualFee,

View 8 Replies

Web Forms :: Context Menu On Treeview?

Jul 10, 2010

Has anyone successfully implemented a node specific context menu on a treeview in any web project?I have populated context menu on specific treenode and able to get the treenode tagname, but i am not able to select the tree node while i right click on the treenode.My code is as follows:

function ShowContextMenu() { var obj = window.event.srcElement; if(obj.tagName == "SPAN") { showhide('ctl00_menuHover','true',obj.tagName);//function to show/hide menu } }
<asp:treeview id="trvMenu" runat="server" datasourceid="SiteMapDataSource1" xmlns:asp="#unknown">
CollapseImageToolTip="Collapse" ExpandImageToolTip="Expand" ShowLines="True" oncontextmenu="Javascript:ShowContextMenu();return false;">

View 2 Replies

State Management :: Response Not Available In Context

Jul 10, 2010

I have configured my web application session timeout to 30 mnts and kept the code

Response.Redirect("Login.aspx")

in the Session End. But when ever my session is ending its giving exception "HttpException was unhandled by user code, Response is not available in this context.".

View 6 Replies







Copyrights 2005-15 www.BigResource.com, All rights reserved