|
This only appears to be a good idea when you are sleep deprived and working on your project at 4am. That's why I drink more coffee. I had to support code like this a few times. Good luck if you are trying to debug the query, especially if the person who wrote it used column indexes instead of column names when referencing the result set.
|
|
|
|
|
Turf Monster wrote: Good luck if you are trying to debug the query
I was reading through the comments and thinking exactly this before encountering your post. (Shudders at the memory).
|
|
|
|
|
At first I was prepared for a flame against the ancient-of-days DAO from Microsoft, which was the data access interface for Access. At least that interface (and still is) useful in a wide variety of applications where the coder is also the database interface guy.
The only time I've ever developed such an abstract interface was for a code transition from the use of Raima's dbVista network-model database to relational DB2 for OS/2. But then, most of the code I write these days is either for SQL Server or for Access but never for both at the same time. I know there are many valid reasons for using LINQ and Entity Framework, particularly if you have a large project where the coders have little or no ability to add or modify the functionality of an existing database, and also for data storage mechanisms that you want to access as if they were relational when in fact they are anything but - and boy am I glad not to be working in projects like that at the moment 
|
|
|
|
|
Works for me.
I write mostly desktop applications using C# (VS2008). Over the last several years I've built a utility library that abstracts SQL access into a very simple set of routines that I use in all my applications. The work is all done. I can very simply connect and interact with SQL databases without having to forever call up a help reference or reconstruct a connection string. The library was fun to develop and debug and now sits there waiting for me to use it when developing another application.
>>It's surprising how many people try to create their own solutions to problems which already have established and well-behaving solution<<
Yeah ... I developed it myself because I wanted a SIMPLE way to do all that. The .Net Framework has tons of features built-in but nothing approaching the simplicity of what I built myself. This is surprising? Not to me. Mature developers have always abstracted "library" code for their own use so they could avoid re-inventing the wheel in SOMEONE ELSE's image.
-Max 
|
|
|
|
|
I agree... I have also written myself plenty of utility libraries over the years writing desktop applications, server software and web applications.
The simple reason why... I want a way that works similar over all my enviroments, and one that *I* can debug if something seems to be going wrong... Or the newest release of PostgreSQL rolls around and they decide implicit casting is evil again 
So yes, I have written my own abstractions because they work the way I think, not the other way around 
|
|
|
|
|
Idunno. My experience is that you mostly have to write only a little glue code which you reuse across LOB apps. The libraries which do real work are in most cases already available. Re-inventing your own custom-built wheel is the wrong kind of laziness - your wheel will need more maintenance than a thin adapter to something built and maintained by others.
|
|
|
|
|
The problem with other people's solutions always is that they are other people's solutions. They usually solve their problems and never quite yours and they do it in a way that suited them best. That's why I usually don't like 'Design by Frankenstein' where your project ends up only being the glue code between every framework and library that could be found.
An example? In a project we needed access to an already existing database. Its design was certainly not the best, but we had no other choice than to use it as it was. Trying to use Hibernate for this was one big mistake. The mappings were correct, but Hibernate constantly was nagging us to improve the database's design and that we should do this and not do that. It took a few creative workarounds to find mappings that Hibernate could live with. I could have found better uses for the time that took than getting a 'smart' framework to do its job.
And let's not forget that (understandably) that each library or framework was designed to solve a very central and important task, so the designers thought a certain use of resources (like memory and the CPU) to be justified. The problem is that all the other frameworks were seen to be just as important by their designers and you can quickly end up with a slow memory hog.
Its hunger for memory was the reason why Hibernate was thrown out of the project. It quickly went through the roof (i.e the server process' memory limit) before even a medium size job was successfully done. Totally unacceptable in productive use when several such jobs could be running at the same time. The problem was the persistance feature of Hibernate, which hogged the memory and was not really needed there. Using a stateless session was impossible because it did not have some of the features we needed.
In the end we threw out the complete resource access layer and Hibernate with it and built a new one with simple ADO.Net queries. We slammed that thing together in two days and it's working without any issues since then and the memory consumption while processing the jobs now is a constant level line.
So, if you ask me, simply go for the most direct way you can and use shiny frameworks sparingly and only after thinking through all possible aspects.
I'm invincible, I can't be vinced
|
|
|
|
|
I agree with you particularly in the case of entity modelling/persistence frameworks. The way someone else thought you should do something is almost never exactly how you have actually done it, particularly if you come in at the point where there already is a database (possibly many years old).
I've had fun fighting NHibernate on a previous project where the database predated the mappings, and in a couple of cases I gave up and just used a direct SQL query because it was much quicker and easier to do so.
In another recent project, which was very short, I wrote a simple entity persistence framework because it was much easier to do that than to work out how to make Entity Framework actually do what we wanted.
Frameworks work really well if you agree at the start that you're going to do things their way. Often that's not possible and, particularly with database mapping but to a lesser extent with every situation, the framework is too hard to adapt to a different situation.
There are a few hard problems out there for which a framework is a timesaver. UI is the obvious big one, and serving content over HTTP is another one. Web services would come in this category too. It's not worth rewriting these, because to do so, even for the limited scope of a single project, would take weeks. But in the case of entity mapping, implementing what you need for your project will probably take a few days, and that's likely to be less time than you'd waste trying to get an existing framework to play nicely with the rest of your code and with your database.
|
|
|
|
|
BobJanova wrote: There are a few hard problems out there for which a framework is a timesaver. UI
is the obvious big one, and serving content over HTTP is another one. Web
services would come in this category too. It's not worth rewriting these,
because to do so, even for the limited scope of a single project, would take
weeks
You are joking, right? Wait a second, I just need to make some new screenshots of the program I'm just working on...
Edit: You can see a bit more when you click on the images and enlarge them to full size
Screenshot 1[^]
Screenshot 2[^]
The project has four webservices, but they are of the normal .Net flavor. There also is a graphics engine for XNA. And the UI I have been working on for a while. At the moment there is no way to control what the 3D engine is doing, so the background is still a little boring. At the moment it just shows two of my first own 3D models to see that the rendering thread is still with us. The two screenshots show the first fully functional views for registering a new user and logging in.
Anyway, I must disagree with you when it comes to writing your own UI
I'm invincible, I can't be vinced
|
|
|
|
|
I should have specified, UI for normal desktop applications. UI within a graphics engine context like this is different, I just wasn't thinking along those lines when I posted before. The difference is that you want your UI to look, well, yours, whereas with a normal application you want it to look like a standard (insert OS here) application so using the standard framework gives you what you want.
I've written personal UI frameworks for games before as well, most recently in Flash (so I don't have to stick megabytes of Flex on my project just to click some buttons).
|
|
|
|
|
Well, it's not just a collection of classes that are hard coded just for this project and act like controls. It implements the interfaces of our older MVP framework, so that we can port the logic from the earlier WPF version. The views are declared with XAML and you have control over every design aspect of the controls. You can completely change the appearance and behavior of all controls from your code, in XAML or in styles and themes. By now the work on the UI has slowly shifted away from the fundamental things to adding more controls or adding more design options to existing controls.
You are right, under normal circumstances I would not have done this myself. But it was interesting to do, especially because I would never get to do it under normal circumstances. Just to think of the heart attack my boss would get if I ever proposed such a thing at work
What did it cost? Lot's of time. What did I gain? I learned a lot and I have a little UI that is mature enough to slowly be of use. And most of all, it's mine. I can give it away or charge insulting prices for it. And nobody in Redmond or elsewhere gets to decide when it's time to stop supporting it
I'm invincible, I can't be vinced
|
|
|
|
|
Ah, well doing things in hobby time is entirely different again. I've reinvented several wheels for the joy of working out how a wheel is put together, too. But even in a business environment it often makes sense to reinvent some frameworks – not usually UI ones, though, unless you're writing something seriously custom.
|
|
|
|
|
In this case it was just how the project evolved. It started out as ASP.Net webpages. A browser game. We could have slammed something together in short time, but that exactly was not our goal. Along the way webpages, even with all kinds of extras (like Ajax) became too limited and boring.
So we kept the entire sever components and added a webservice and a simple Windows Forms client. For this we wrote a little MVP framework and got a good performance with asynchronous webservice calls. Adding the first modest incarnation of the 3D engine to run in a WinForms control also worked reasonably well. The only problem was the somewhat ugly look of Windows Forms.
That's why we tried a WPF client. It was just a matter of porting our MVP framework to WPF and then making new Views while keeping the rest of the logic. Now we had a great UI, but getting the 3D engine to work in a WPF control turned out to be a problem. It always had performance problems or involved some ugly (and unsafe) hacks.
Turning things around and bringing the UI into the 3D application was the only way left to go. I looked at all the XNA UI projects I could find. Some were too simple, some were not really mature enough to be of any use and some were good but no longer in development. I think that writing a new one from scratch was no bad decision, at least if you really can pull that trick off. Now the appearance and performance of the client lies entirely in my hands.
Well, not entirely. My Padawan is getting ready to get his hands on the themes and styles and probably is going to redesign everything what you have seen in the screenshots. And he will probably come with millions of changes to the controls
I'm invincible, I can't be vinced
|
|
|
|
|
You have a point with some of this. I've not played with Hibernate yet, but for Entity Framework I have the feeling it works quite well when you're designing from scratch - your schema evolves to match the model.
In the real world though there are many huge legacy databases, often shared by your app and others. If there's a mismatch between models it often involves more code adapting the framework to your usage than if you'd coded a small layer to do the job.
Too much developer guidance, IMHO, ignores this factor.
|
|
|
|
|
I came across the following, working on some one else's project:
pingHost pping = new pingHost();
if (!pping.ping("www.google.com")) {
MessageBox.Show("The application is unable to connect to the internet and cannot continue.")
return;
}
So, I take it that Google IS the internet.
What's more, this app runs on a VPN and in some cases on a LAN where the server is in the same building.
I wonder how many seemingly unrelated applications, neigh, systems, will EPICALLY FAIL throughout the world the day Google dies or decides to block ICMP requests. 
(Maybe that's the event the Mayans predicted for 21 December 2012?)
|
|
|
|
|
MatthysDT wrote: So, I take it that Google IS the internet.
Considering how big they've gotten over the years... it's pretty close...
|
|
|
|
|
I thought only non-programmer check google to test their internet connection 
Even I, sometimes open google to check internet cnnection,
But on the other hand, what should one code to test their internet connection....
|
|
|
|
|
Well, in a client-server application you should know the address of the server, so I'd say that's the address you need to ping, or better yet, make a socket connection to the server port.
Even if it's only SQL, if you can connect to port 433 (in most cases), you probably have connectivity. Some servers may block ICMP requests, so that's never a good option.
|
|
|
|
|
How do you differentiate between "Our server has gone boom, hoepfully our internal monitoring app has paged a sysadmin to fix it." and "Your Internet connection is busted; yell at your ISP." Testing several major internet sites is really the only way to go there since I've encountered more than a few cases where something in my/my isps networking gear went splat and Windows never got a clue.
Did you ever see history portrayed as an old man with a wise brow and pulseless heart, waging all things in the balance of reason?
Is not rather the genius of history like an eternal, imploring maiden, full of fire, with a burning heart and flaming soul, humanly warm and humanly beautiful?
--Zachris Topelius
Training a telescope on one’s own belly button will only reveal lint. You like that? You go right on staring at it. I prefer looking at galaxies.
-- Sarah Hoyt
|
|
|
|
|
|
internetgetconnectedstate has always worked for me. You still have to check the availability of the resource.
"Go forth into the source" - Neal Morse
|
|
|
|
|
Someone I know *cough* *cough* once used that approach. They pinged a machine in the building. If the response was successful, the UI for the application was, ahem, altered in a particular way. A checkbox that represented a spectacularly stupid idea was renamed to "Steve mode", where the aforementioned 'Steve' created the idea.
Software Zen: delete this;
|
|
|
|
|
A reverse easter egg.. I love it 
We can program with only 1's, but if all you've got are zeros, you've got nothing.
|
|
|
|
|
Sometimes you have network but not internet.
The better way to test it, is to use a well know network host or IP.
If you only want to check if you have network connection and it is good, check for a host like Google is the better choice.
Or, you can check for a Registrar, like 'registro.br' here in Brazil.
But I rely more on Google than an Registrar, 'cause I never saw and never heard someone speaking that Google was down.
|
|
|
|
|
A LAN in the same building is not the internet. Works as intended
modified 20-Oct-19 21:02pm.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
#FACT
