WebLog of Ken Cox - All Comments

re: Fixing the System.Data.UpdateException – DefiningQuery and no Error

Klaus Ahlbäumer — Tue, 31 Jan 2012 06:10:21 GMT

Thank you for writing your experience into this blog.

So it took me only a few minutes to fix the problem.

re: Fixing the System.Data.UpdateException – DefiningQuery and no Error

Dan — Fri, 27 Jan 2012 05:11:17 GMT

Old post, still relevant... DOH! Forgot the Primary Key... Guess that happens when you haven't created a DB table in 3 months... Thanks, bud! *cheers*

re: I Owe $282.06 for Windows Azure Usage Charges on an MSDN Subscription

Chris Smith — Sun, 22 Jan 2012 01:08:25 GMT

Just so I don't sound like an idiot: I'm a solution architect and have been using the .Net platform for about 10 years now (since beta!). I've built massive SaaS applications that run on hundreds of servers and big commercial web sites.

Whilst I haven't been screwed (yet), I was ashamed to find out that my trial storage transactions for the month are half gone from deploying a todo list around 15 times. I mean what the?

When projecting it across our current application and deployment, it would cost about $25,000 a month to sustain. Our current pricing (with our own kit, hosting costs, sole staff member and trips to the data center) turns out at around $15,000 a month and a fair chunk of that's going out of the window when we dump SQL server for postgresql.

So it's not cost effective for both small LOB applications and large ones? What good is it?

Considering all the "features" which are not portable once you've implemented them (service bus, worker roles etc), once you've built it, you are screwed properly. AppFabric on Windows server is not the same. Total disaster.

Rackspace, cheap VPS and AWS are far cheaper with no API lock in and vendor lock in.

In fact, it'd probably be better to use PHP and Postgres or something on Linux.

Oh and don't even get me started on how long it takes to deploy. I can shift a 2500 file deployment package to a Linux machine with rsync over ssh in 10 seconds flat. Compare that to 5 minutes with azure to shift a couple of static pages over.

Sorry rant over.

re: Fix: 'Unable to load one or more of the requested types' Errors

John K. — Sun, 15 Jan 2012 15:35:48 GMT

Thank you so much for posting this. I had the identical problem going from dev to prod env. Would have never figured this one out without your help.

Thanks!

re: Using the SQL Table Profile Provider in ASP.NET 4 Web Applications (C# & VB)

sebastianh — Wed, 11 Jan 2012 12:52:55 GMT

Hi Ken, great code. thank you. I included on my website with success for authenticated users, on the other hand I dont know how I can include anonymousidentification to profiles using the proposed scheme. I´m trying to use AnonymousIdentification_Creating in global.asax but with limited success. Do you have the chance to shed light on the best approach to use anonymousidentification=true with sql table profile provider?. Brgds!

re: Full Trust Strikes Again

Gizzi — Tue, 10 Jan 2012 03:26:38 GMT

this totally bytes! i've had to rebuild my whole website because it won't run the controls I love soo much like collapsible panels and the like!

re: Oracle 11G and SqlDataSource: The ugly 'ORA-01036: illegal variable name/number' Issue

Subhasis — Mon, 09 Jan 2012 12:36:35 GMT

I am using it in below format and it works for me:

===== aspx ====

<asp:SqlDataSource ID="SqlDataSource3" runat="server" ConflictDetection="OverwriteChanges"

ConnectionString="<%$ ConnectionStrings:ConnectionString %>"

ProviderName="System.Data.OracleClient"

...

InsertCommand="INSERT INTO PROBLEM

(NAME, PROBLEMTEXT, PROBLEMTYPE, DESCRIPTION, EVENTID)

VALUES (:NAME, :PROBLEMTEXT, :PROBLEMTYPE, :DESCRIPTION, :EVENTID)"

==== aspx.cs ====

protected void GridView3_RowAdding(object sender,

GridViewUpdateEventArgs e)

{

if (e.RowIndex > 0)

return; // RowIndex=0 is the row we want to insert

System.Collections.Hashtable h =

new System.Collections.Hashtable();

foreach (System.Collections.DictionaryEntry x in e.NewValues)

{

h[x.Key] = x.Value;

SqlDataSource3.InsertParameters[x.Key.ToString()].DefaultValue = x.Value.ToString();

}

SqlDataSource3.Insert();

====

re: ASP.NET/IIS Fix: The 'Microsoft.Jet.OLEDB.4.0' provider is not registered on the local machine.

Karthik.M — Mon, 02 Jan 2012 12:46:04 GMT

Very very thanks for your golden information, I fixed this error, Now its working properly.

re: Fixing the System.Data.UpdateException – DefiningQuery and no Error

HasanRizvi — Sat, 31 Dec 2011 02:17:39 GMT

This is the case for me. Simply removing <DefiningQuery> resulted in another error. I followed the steps of this post except the last one. For your convenience, I copied the 4 steps from the post that I followed to solve the problem as following:

Right click on the edmx file, select Open with, XML editor

Locate the entity in the edmx:StorageModels element

Remove the DefiningQuery entirely

Rename the store:Schema="dbo" to Schema="dbo" (otherwise, the code will generate an error saying the name is invalid)

re: Stupid web.config mistake: Sections must only appear once per config file

Charlie — Tue, 27 Dec 2011 16:19:24 GMT

This is great! Saved me frustration. I copy/pasted a location chunk for a page where I added a new role, but that same page was in the web.comnfig file eariler in the file for the old role it was in before. Dumb. Thanks.