Database
There are 12 entries for the tag
Database
When we decided that ParaPlan 4.0 would be rebuilt in .NET (from Access), we decided not to redesign the SQL database. Even though we have some inefficiencies in our db we want to decrease development time and allow our beta testers to be able to switch back and forth between our Access front end and our .NET front end. As development began, we decided that we needed an object for each table and that we could eliminate some of the database inefficiencies in our objects. So we have an Appointment...
I have a couple helper methods that I use all the time during my data access layer. I figured I might as well post them and hopefully help others out. I use the code from this article to pull my field names, that way I can build code like this:public override IEntity PopulateFromOpenIDataReader... dr) { const int ID = 0; const int NAME = 1; const int COMMENT = 2; const int ADDRESS1 = 3; const int ADDRESS2 = 4; Doctor rv = new Doctor(); rv.ID = (int)DataValidation.GetValu... ID, 0);...
I updated my article of the class to extract constants from a database for clean code freaks like me that want every field name to be defined by a constant. The original post is here. The code is here. Technorati tags: C#, code comments, .NET, Database...
Update: 02/27/2007 added support for raw SQL Strings When I build data access layers, I like to define a const for each column in the query like this: const int CLIENTID = 0; const int STATUS = 1; const int FIRSTNAME = 2; That way, I can pull data like this: newClient.Name.FirstName = reader.GetString(FIRSTNAME); And if something changes in the database, I know I only have to change the field that FIRSTNAME references. However, sometimes, tables can be quite large and it becomes a pain in the wrist....
Scrybe has potential. It is a personal web based organizer that has "human nature" built in. It looks like it was designed by somebody that has no idea how to write software or what a database looks like. Which can be a good thing as far as user experience goes. I tried Google's calendar for a while, but Outlook was still better because I can associate contacts with events, and sync everything automatically with my PPC-6700. If Scrybe can add those things, I might switch. Technorati tags: Scrybe...
Where's Tim has been getting a lot of attention lately. And as I watched Matt drive around the other day, I realized there is something very interesting about seeing him move across the map. When it comes to business applications, knowledge is money. Our ParaPlan Pro application supports geocoding, which means we can transform a street address to a latitude and longitude. So for each of our client's trips, the software knows when that person was supposed to be picked up, and the exact lat/lon coordinates...
It's official! EnGraph has begun development on the migration of our flagship product, ParaPlan to .NET. We have several little helper applications that are written in .NET, but our main core is still an Access front end hitting a SQL database. We are completely redesigning the user interface, business rules and database structure in the new ParaPlan, code named "Goldstar". We have been talking about and planning this for almost two years, it's very exciting to see it move to the next level. Kyle...
I usually don't buy products from companies that have shiny happy people on their websites. I think it's tacky. I may make an exception for godaddy.com though. Their prices look good and I will get a lot more disk space for the same prices as webhost4life. The only think I couldn't find is how much database space I get. Plus the owner blogs...
One of our applications is an Access front end linked to a SQL backend. We link the tables and then all the database calls go against an ADODB connection. This weekend, I was supposed to do a major upgrade for one of our clients. This upgrade was going to involve changing the database structure, so I had the DBA add drop and create table permissions to my SQL login. Once the login permissions were changed, our application stopped working. The first place a data call was made, we would get a "could...
I have finished creating Record Activity Tracker, known to me and Kyle as RAT. Our original database doesn't have fields for datestamps. We can't really modifiy the existing structure because it is too hard to update clients, so we created a new table that handles all the record update/create activity. Read the “official“ version on the news page of our Website
When migrating an access application to sql server, sql changes all your access date/time fields to sql date/time format. Well, with access you can store the data as any type of date format (short time, long date, etc). Sql stores it all in one format (ex: 05/28/1979 12:48:00). Thats fine, because usually you have control over the data before the end user ever sees it and you can make it look nice with a FormatDateTime or whatever. Well, I ran into a case today, where it was just better to bind a...
Well, after attending DevEssentials in Kansas City and listening to Jeff Julian speak on the importance of community and blogging your individual development efforts, I decided it would be a good idea to start blogging on my own. I have been moblogging for a while, but this is my first official text post. I live in Lawrence, KS and develop in .net, SQL, and VBA Access for a small virtual company. I have been programming ever since my Dad gave me a Mac Plus and ZBasic at the ripe age of 10. I also...