John Nicholas

Manchester, United Kingdom

NA

Age: 34

slightly crazed .net junkie.

Developer since 2000. Consciously decided to go the MS route due to their tooling.

fairly serious guitarist (7 years or so - currently learning lots of old blues, Howling wolf etc) and am increasingly spending time getting back into Go.

Current specialisms: SQL, EF40 + T4, WCF, linq, lambda, silverlight4, moq, pex, moles - anything needed to get the job done really.

Nov
24
awarded Autobiographer
Nov
17
revised Read SQL Table into C# DataTable
updated again to show what i think is preferable to dataset.
Nov
17
revised Read SQL Table into C# DataTable
updated to save people having to read the garbage below in the comments.
Nov
17
comment Read SQL Table into C# DataTable
I was answering a question that was asked. In the context of that my answer is perfectly valid, still is and I stand by it. You have come in with some irrelevant problem that is not being asked about and saying 'well in this case you have a problem huuur'. Well yes perhaps, but I still maintain I can code to your problem and STILL be correct at the level this question is being asked at. I am not sure what your point is, you are must be trolling. You haven't once shown how datasets would help in the area you are talking about - they are irrelevant so I name you 'troll'. Congratulations.
Nov
16
comment Read SQL Table into C# DataTable
I can easily query a table, find the types in it and assert that those types are co / contra variant to the types being expected at runtime. Otherwise you are simply asserting a tautology. You are pointing at the layer that provides type safety and saying look you cant write this in a type safe way. And well of course you can't, you defined the problem so you couldn't, however you can write that layer to be able to query the database schema itself so that it can do its job as an adapter and expose the database in a strongly typed way. why use c# if you don't want this?
Nov
14
comment Read SQL Table into C# DataTable
It has access to types due to meta data tables and the fact the 'ss' refers to sql server. If you want to ask me direct questions i would be happy to try and answer. That last one had very little effort - lets suppose i already was? now what?
Nov
13
comment Read SQL Table into C# DataTable
Sql is given. Besides, if you don't know what kind of database then why does it even have to be a database? What would be the application of such a generic tool? If you ever need to connect to databases that are really so radically different you would abstract away from it behind a repository pattern and then inside of that you would need different specialized database adapters and at that point you would know about the specifics. The fact is consuming code has type expectations -> type assertions in adapter. Your constraint means you have no idea about database language and so cannot query.
Nov
7
awarded Notable Question
Oct
13
comment Unit testing code that uses Task.Factory.StartNew().ContinueWith()
this looks interesting, when I run into this problem again I will remember to come back to this answer :D I did something similar.
Oct
9
awarded Nice Question
Oct
4
comment Read SQL Table into C# DataTable
Typed datasets in .net are a horrible creation of xml madness and woe. I have never worked in a place that is willing to accept the overhead of maintaining all that for a microsofts typed datasets. I don't think even microsoft suggests its sensible these days. As for type safety with multiple databases of course you can get it - the point is that you convert it into typed collection asap and pass that about so that you restrict the type issues to a specific place. Orms will help with that and work perfectly well with multiple databases. If you don't like EF use something lighter like dapper.
Sep
4
answered Why does a wave actually diffract?
Aug
20
comment What is a (proposed) “Record” class in C# 6?
kidna funny as there was nothing stopping you doing this by hand before - except that all the microsoft technologies depend on having writable properties for serialisation, orm layers etc. I hope this implies that they intend to change these so we can have objects with predictable state in the future. IE cool stuff, but how can you really use them given current state of play (no pun intended)
Aug
9
awarded Popular Question
Aug
4
comment Inserting data with Dapper with DateTime2 throws SqlDateTime overflow exception
also the line number is now wrong, can you link to the function or test instead? (I don't know if you can)
Jul
30
revised Fill value by default form in .NET
added 243 characters in body
Jul
30
answered Fill value by default form in .NET
Jul
30
awarded Autobiographer
Jul
30
comment How can I test out my equipment before a backpacking trip?
Having something and discovering it isn't suitable for the role you require it for are 2 very very different things. It could be as simple as antiseptic wipes that are far too dry all the way up to densities of cloth for bandages. Many first aid kits rapidly become wholey inadequate as you approach the extremes of injuries you really need to treat - yet a cursory examination or check list would find them equal.
Jul
26
accepted mvc begin form cant make routing override work
1 2 3 4 5