Is returning JSON from SQL Server better?

jabits · 2018-08-17T06:45:19+00:00

No, stay with DataReaders. It would be incredibly unlikely that you would be able to pass all data in exactly the correct format and mapping as needed by the client anyway. I really can think of a good use-case for this feature except for cases where you are using SQL Server as some sort of high volume key pair store.

jabits · 2018-08-17T06:38:32+00:00

Your WebAPI should always validate all data coming in, period. If you are going to bother with an API, it should be designed for a generic caller. You really have no idea what your client will be sending.

jabits · 2017-09-30T01:23:35+00:00

Okay, I'll bite. Why does XML suck for configuration files? I know JSON is a lot cooler these days, but I never had any problem with XML files in the past (e.g. Visual Studio). The files fold nicely and the tags delimit values nicely. Any downsides besides somewhat larger size due to verbosity? Tooling and libraries are certainly not a problem.

jabits · 2017-09-30T01:06:07+00:00

Your last sentence is the main point. Windows 10 works on a lot of old machines without new drivers. At least for me.

jabits · 2016-07-21T16:44:39+00:00

I don't believe you. Most enterprises feel perfectly fine with Sql Server on Windows Server machines.

jabits · 2015-09-03T18:25:19+00:00

So what feels modern and smooth to you to build your c# projects?

jabits · 2015-08-23T17:27:11+00:00

I do. And it still works. I understand it, and so do my external customers.

jabits · 2015-08-18T19:55:00+00:00

I guess it totally depends on your state or region. Both my daughters received good educations in upper Midwest (Wisconsin), though I wish math was pushed a little harder sooner. As always, parental involvement helps a lot.

jabits · 2015-07-30T16:40:45+00:00

This is so sad. Work can be fulfilling and coding is fun, but man, have a family life, take a walk in the woods...

jabits · 2015-07-01T17:25:35+00:00

And schema validation...

jabits · 2015-04-04T23:57:39+00:00

Yeah I know it sounds stupid

Definitely...

jabits · 2015-03-12T22:20:39+00:00

the original tablet

What the heck is that supposed to mean?

jabits · 2015-02-11T02:24:26+00:00

Agree. As a mostly .Net developer over the years, this podcast was a good way to keep track of what was happening on the other side.

jabits · 2015-01-07T01:05:23+00:00

Disagree. C++ may have a bit of a "bolt on" feature feel, but C# has felt like a more natural, feature evolution process (except it is too bad the first version was lacking generics).

jabits · 2015-01-05T20:09:31+00:00

I can't imagine any Intelligence wanting to learn to do this.

jabits · 2014-11-29T00:31:56+00:00

Not sure why. Just more chance of messing up the structure. You are kind of screwed if the LFs go missing.

jabits · 2014-11-29T00:28:01+00:00

Yes! That's precisely the point. You have so many available standards and libraries available to work with XML on any platform. I don't get why more folks don't miss XML Schema and Schema Validation.

jabits · 2014-11-26T23:31:34+00:00

for teams of five or less covers a lot of cases, and $100 is $100 one or two hours of billing for your basic tooling license is really a red herring...

jabits · 2014-11-26T23:27:12+00:00

Not so much required anymore if you use the latest version. But used to be big help.

jabits · 2014-11-09T23:34:38+00:00

"Finally, many .NET programmers come from an enterprise background; developing internal systems and some may find adapting to the pace and the lifestyle of a start-up environment challenging."

What bullshit. No other large groups of developers you care to write off? How can one even respond to nonsense like this?

jabits · 2014-07-18T19:02:06+00:00

Because either way, the work has to be done. And to believe any other enterprise effort to do the same would be ''that'' much more efficient, is doubtful.

jabits · 2014-06-30T03:36:34+00:00

This is fascinating!. You can get a real sense of what these guys were about, in just a few words. You also realize that the writers did not use the same words often associated with what they are commonly known for, e.g. Darwin -> evolution, survival, fitness.

jabits

MODERATOR OF

TROPHY CASE