Configuration:
1) IIS and AD on different computers
2) IIS - integrated windows authentication
3) web.config -
4) IIS netbios name -- SERVER, dns - server.domain.com
5) web method test in test.asmx which translates User.Identity.Name to AD
distinguished name:
ActiveDs.NameTranslate nt = new Acti
The Oracle equivalent is called a sequence, which works slightly differently than an
identity column. You can have multiple sequences and track each one separately. And
yes, sequences work with all the variations of Command.UpdatedRowSource with all the
Oracle .NET data providers that I've trie
Is it possible to write/overwrite a file on a web server with the HttpWebRequest Class
? I am currently using HttpWebRequest to read a file from a web site and need to know
if I can also write the file, given I have permission to do so. I know I can't seek,
but can I write ? Is there any way
Hi,
Oracle equivalent is to pre-fetch next value from the sequence
and use it as PK of parent row and FK of child row. Beside that, there
is no direct equivalent for @@identity/scope_identity().
So, it would be one more argument for using GUID as PK. And if you f.e.
right shift whole GUID
And reason number 4: They are available for purchase on eBay.
Steve Holak
Senior Software Architect
Brokerage Concepts IS Dept.
610-491-4879
email: [EMAIL PROTECTED]
"Beauchemin, Bob"
<[EMAIL PROTECTED]> To:
[EMAIL PROTECTED]
Basically only because @@identity may return an identity from a table
outside the scope of your current session. If you are in a data entry
multi user scenario I reckon it is pretty essential - otherwise POSSIBLY
unnecessary but best practise or at least received wisdom as I
understand it. You mig
@@IDENTITY will return the last identity value after any triggers have been
called (i.e. you could end up getting the identity of an updated record in
another table as a result of a trigger).
SCOPE_IDENTITY() returns the identity of the current scope, ie. The identity
of the table you insterted/u
hi
it still didn't answer the question.
how do you update the child rows with new added father unique key?
yosi
On Sun, 7 Jul 2002 07:42:40 -0700, Avi Nahir <[EMAIL PROTECTED]> wrote:
>http://msdn.microsoft.com/library/default.asp?url=/library/en-
>us/cpguide/html/cpconupdatingdatabasewithdat
Are you concerned about security -- i.e. a malicious user sticking a bad assembly in
your bin directory, for some evil purpose?
Why not sign your DAL assemblies, and use the fully-qualified assembly-name when
calling Activator.CreateInstance?
Here's what that code looks like, when instantiatin
Are you saying that it is better to use the classes methods than pass it
over Mike? True, and it would be fine though I would imagine to compile
what you have posted you might need to make the return type an integer.
If you are wishing to pass the class to a remote process you are talking
"Remoti
http://sqlwire.com/brief.asp?1985
The Cost of GUIDs as Primary Keys
Article: Posted 3/19/2002
Source: JNSK
In this article, Jimmy Nilsson presents the pros and cons of using GUIDs as
the datatype for primary keys in SQL Server 2000. In doing so, he shows you
test results that hint of performance
Thanks Paolo and Yves!
I've located this, which may be of interest:
http://www.clrgeeks.com/Papers/HostingASPNET/index.html
You can read messages from the Advanced DOTNET archive, unsubscribe from Advanced
DOTNET, or
subscribe to other DevelopMentor lists at http://discuss.develop.com.
I posted an issue on this on the WEB list, but no response, have done some
further digging, and have found something peculiar that I would like to
have explained.
Briefly, I have an ASP.NET Web datagrid with three button columns and an
Edit Command Column. The grid is configured in the aspx page
I agree if im using my own objects I would use a GUID as part of your
arguments but when using Datasets you dont have the issue with identiy
primary keys. - See our other discussion.
Ben
-Original Message-
From: Moderated discussion of advanced .NET topics.
[mailto:[EMAIL PROTECTED]]On B
Thanks for the timer info - I agree there is something new. Doing better
than 10 ms was always difficult appreciate the code.
Regarding the thread model. What I was trying to say was there is no real
case for the 300 Thread model . The 300 Thread model would give the quickest
time to respond. eg
However, I notice that Chris Anderson has answered my question - you do it
with two round trips. First, INSERT the new parent row, and you get back
the new identity value. If you have an appropriate foreign key constraint
set up on your DataSet, the act of updating the parent row's identity will
Why SCOPE_INDENTITY() rather than @@IDENTITY ?
Also is there an Oracle equivalent ?
Ben
-Original Message-
From: Moderated discussion of advanced .NET topics.
[mailto:[EMAIL PROTECTED]]On Behalf Of Iain Smallwood
Sent: Monday, 8 July 2002 4:46 PM
To: [EMAIL PROTECTED]
Subject: Re: [ADVA
>But someone recently showed me if I make 2 Assemblies with the exact same
NameSpace
>and class names and they both Implement the Interface. I can simply drop
the assembly
>in the Bin directory and as long as all the names are the same the CLR will
load
>the class from whatever Assembly is in the
Only one other drawback, but other reasons to want to use GUIDs.
1. They are pretty much the only way to ensure true multi-master merge replication.
2. They appear to be nicely supported by the .NET framework and ADO.NET.
3. They are random, optimizing key ranges and making it more difficult fo
I Don't quite know what you mean. Inferrence of the schema in a DataSet
is the inference of the DataSet Schema.
Thanks,
Shawn Wildermuth
[EMAIL PROTECTED]
> -Original Message-
> From: Moderated discussion of advanced .NET topics.
> [mailto:[EMAIL PROTECTED]] On Behalf Of Nick Dunlop
>
20 matches
Mail list logo
