Wrox Programmer Forums

Need to download code?

View our list of code downloads.

Go Back   Wrox Programmer Forums > Search Forums
Password Reminder
Register
| FAQ | Members List | Search | Today's Posts | Mark Forums Read
Welcome to the p2p.wrox.com Forums.

You are currently viewing the section of the Wrox Programmer to Programmer discussions. This is a community of tens of thousands of software programmers and website developers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other developers’ questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free .
DRM-free e-books 300x50
Showing results 1 to 25 of 338
Search took 0.02 seconds.
Search: Posts Made By: SQLScott
Forum: BOOK: Professional LINQ September 10th, 2009, 04:06 PM
Replies: 6
Views: 5,004
Posted By SQLScott
A quick test would be to create a completely...

A quick test would be to create a completely seperate VS 2008 project and gen the model via the OR and run the same code. That should be a fairly quick test and provide some insight...
Forum: BOOK: Professional LINQ September 10th, 2009, 04:05 PM
Replies: 6
Views: 5,004
Posted By SQLScott
Was any of it generated via OR or Sqlmetal?...

Was any of it generated via OR or Sqlmetal? Meaning, from your last post, it sounds like you generated the model via OR or SqlMetal but added the Account entity manually. I know that is doable but I...
Forum: BOOK: Professional LINQ September 10th, 2009, 01:34 PM
Replies: 6
Views: 5,004
Posted By SQLScott
Two things come to mind. First, I would regen the...

Two things come to mind. First, I would regen the model. Something probably got whacked when you were making changes and it thinks there is no primary (identity) key. Second, did you make any changes...
Forum: BOOK: Professional LINQ September 9th, 2009, 10:32 PM
Replies: 4
Views: 2,578
Posted By SQLScott
I appreciate your comments. Great feedback. Keep...

I appreciate your comments. Great feedback. Keep in mind that most books like these are are written with Beta 1 and early Beta 2 bits, so things like this, things that you are finding, occur. So, let...
Forum: BOOK: Professional LINQ September 9th, 2009, 07:57 PM
Replies: 4
Views: 2,578
Posted By SQLScott
Hi, The solution is to use the...

Hi,

The solution is to use the InsertOnSubmit method. I'm not sure when this was changed, and I will find out, but the code below shows how this is used:


try
{
using (TransactionScope ts...
Forum: BOOK: Professional LINQ July 17th, 2009, 04:56 PM
Replies: 2
Views: 13,386
Posted By SQLScott
Hi Josi, If you want to use LINQ to execute...

Hi Josi,

If you want to use LINQ to execute that query, I would put it in a stored procedure and execute that proc via LINQ. Should be very easy to do. There are examples of executing procs in...
Forum: BOOK: Professional SQL Server 2005 XML ISBN: 0-7645-9792-2 June 22nd, 2009, 08:49 PM
Replies: 2
Views: 2,702
Posted By SQLScott
Hi Ash, I've had this problem as well. The...

Hi Ash,

I've had this problem as well. The date going in needs to be in datetime format and 1998-06-01T00:00:00 does not meet that criteria. For example, the following is datetime format:
...
Forum: BOOK: Professional SQL Server 2005 XML ISBN: 0-7645-9792-2 April 6th, 2009, 09:37 PM
Replies: 3
Views: 6,333
Posted By SQLScott
Hi Pixelwiz, Thanks for the post. I am not a...

Hi Pixelwiz,
Thanks for the post.
I am not a coldfusion developer, but I do know that there is a point in SQL Server 2005 where XML becomes nearly unusable. I hate to say that because I really do...
Forum: BOOK: Professional WCF Programming: .NET Dev with Windows Communication Found ISBN: 9780470089842 February 3rd, 2009, 01:46 PM
Replies: 11
Views: 9,864
Posted By SQLScott
Testing now and will have it posted shortly...

Testing now and will have it posted shortly...
Forum: BOOK: Professional WCF Programming: .NET Dev with Windows Communication Found ISBN: 9780470089842 January 29th, 2009, 09:18 AM
Replies: 11
Views: 9,864
Posted By SQLScott
Feel like a total Flake

yep...I feel like a total flake for not keeping my promise on the appendix example.

I am working on this example RIGHT NOW and will post here no later than Monday. This time I promise. And...I...
Forum: BOOK: Professional LINQ January 29th, 2009, 09:07 AM
Replies: 0
Views: 2,779
Posted By SQLScott
Misnamed element on page 148-149

Hi Everyone,

I have had several questions regarding a misnamed element in this book in an example on pages 148 and 149. The element shown in the book is <yomoma>.

This is NOT correct and I...
Forum: Pro Visual Basic 2005 September 11th, 2008, 07:42 PM
Replies: 1
Views: 1,782
Posted By SQLScott
Scheduled Task for Windows XP

Does anyone know how to programatically create a Scheduled Task for Windows XP using either C# or VB?

Thanks...

========================
Scott Klein
Author of:
Professional SQL Server 2005...
Forum: SQL Server 2005 June 25th, 2008, 11:29 AM
Replies: 1
Views: 1,016
Posted By SQLScott
Figured it out: x.value('../../@id[1]'...

Figured it out:

x.value('../../@id[1]' ,'int')

I really need to use XML more often so I don't keep forgetting it...

========================
Scott Klein
Author of:
Professional SQL Server...
Forum: SQL Server 2005 June 24th, 2008, 09:49 PM
Replies: 9
Views: 2,780
Posted By SQLScott
Well, personally I never connect directly to an...

Well, personally I never connect directly to an mdf file. I have written several applications against SQLExpress and each time I use the same type of connection and connection string:
...
Forum: SQL Server 2005 June 24th, 2008, 09:42 PM
Replies: 6
Views: 1,482
Posted By SQLScott
lol...yeah..old habits are hard to break. I still...

lol...yeah..old habits are hard to break. I still use the /* */ to comment sql code...

========================
Scott Klein
Author of:
Professional SQL Server 2005 XML
Professional WCF...
Forum: SQL Server 2005 June 24th, 2008, 04:08 PM
Replies: 1
Views: 1,016
Posted By SQLScott
XML question for you XML Gurus

Given the following XML, how would I return the BranchID, PeriodType, StartDate and EndDate all in the same query:

I have the following, and I want to add the id attribute from the Branch element:...
Forum: SQL Server 2005 June 24th, 2008, 02:49 PM
Replies: 3
Views: 972
Posted By SQLScott
Chubnut, Replication adds the...

Chubnut,

Replication adds the uniqueidentifier columns to the database for replication purposes only. They will not, and are not, displayed to the end user. Nor will your application even know...
Forum: SQL Server 2005 June 24th, 2008, 02:44 PM
Replies: 6
Views: 1,482
Posted By SQLScott
Or instead of a #temp table, why not use a CTE? ...

Or instead of a #temp table, why not use a CTE?

========================
Scott Klein
Author of:
Professional SQL Server 2005 XML
Professional WCF Programming: .NET Development with the Windows...
Forum: SQL Server 2005 June 6th, 2008, 04:13 PM
Replies: 1
Views: 1,021
Posted By SQLScott
Since this is an undocumented stored procedure,...

Since this is an undocumented stored procedure, your chances of finding out what these values mean are probably slim to none.

Did you try sys.dm_db_index_physical_stats?

...
Forum: SQL Server 2005 June 6th, 2008, 03:50 PM
Replies: 1
Views: 961
Posted By SQLScott
Did you get this solved? I can take a look at it...

Did you get this solved? I can take a look at it for you if you'd like...

========================
Scott Klein
Author of:
Professional SQL Server 2005 XML
Professional WCF Programming: .NET...
Forum: SQL Server 2005 June 6th, 2008, 03:40 PM
Replies: 1
MDX
Views: 1,603
Posted By SQLScott
http://forums.microsoft.com/MSDN/ShowForum.aspx?Fo...

http://forums.microsoft.com/MSDN/ShowForum.aspx?ForumID=83&SiteID=1

However, we are more than happy to help you out here if we can. Post your question and hopefully someone where can answer it.
...
Forum: SQL Server 2005 June 6th, 2008, 03:38 PM
Replies: 1
Views: 1,763
Posted By SQLScott
Just to be sure, you have your server...

Just to be sure, you have your server authentication set to mixed mode (SQL Server and Windows authentication mode)? If you are selecting SQL Server authentication when you log in, is the login you...
Forum: SQL Server 2005 June 6th, 2008, 03:35 PM
Replies: 1
Views: 890
Posted By SQLScott
Absolutely! What is the data source of your XML? ...

Absolutely! What is the data source of your XML?

========================
Scott Klein
Author of:
Professional SQL Server 2005 XML
Professional WCF Programming: .NET Development with the...
Forum: BOOK: Professional WCF Programming: .NET Dev with Windows Communication Found ISBN: 9780470089842 February 25th, 2008, 10:05 AM
Replies: 9
Views: 2,314
Posted By SQLScott
The EnlistVolatile has two overloads, one which...

The EnlistVolatile has two overloads, one which supports a two phase commit and another which supports a single phase commit. The IEnlistmenetNotification enlists a volatile resource that supports a...
Forum: SQL Server 2005 February 18th, 2008, 01:49 PM
Replies: 4
Views: 3,977
Posted By SQLScott
No, but you could use NEWSEQUENTIALID(), which I...

No, but you could use NEWSEQUENTIALID(), which I wouldn't recommend because, per BOL: If privacy is a concern, do not use this function. It is possible to guess the value of the next generated GUID,...
Showing results 1 to 25 of 338

 


All times are GMT -4. The time now is 03:11 AM.


Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.