Database

There are 6 entries for the tag Database
So I was hoping this post would be a glorious review of my first attempt at working with WebParts and Oracle. Alas, the experience has not been so glorious. I am working on a "dashboard" of sorts as a demo for my boss. I spent a few hours on it this afternoon as a spike to see if the approach is feasible. I have to say that I believe it is, but there is one major kink I have to work out. ASP.Net WebParts uses the SqlPersonalizationProvider by default. Unfortunately, we are developing on Oracle. However, ......
I had the opportunity today to write some more complex LINQ queries. First, I started with a simple group by expression allowing me to subtotal some data for a particular key. Certainly I could have done this in the database. Many would argue that that the database is the expert at these sorts of things, so we should let the expert take care of it. I have a couple of reasons for placing the group by in the LINQ query. First, I don't have a lot of control over the data layer. Second, I can unit test ......

The Load event came to my rescue

Well, I have been playing with Linq, specifically with Oracle. First of all, the only way I could find to make this work is to use a third party software, OraDirect.Net by Core Lab. Their product is great. Perhaps that statement is biased by the fact that they are the only one's building a library to support Linq to Sql (as far as I know). There is certainly room for improvement. I've crashed VS a few times because I was trying to force OraDirect to do something it doesn't support. So, error handling ......
Last week I started working on the build scripts for my new project. I've worked on build environments in the past, but I didn't really commit everything to memory. Thus, I have had to reinvent the wheel in some ways. So far I have established commit and nightly builds. Each build cleans up after the previous build, retrieves the latest source, compiles the application, and runs the tests under coverage. The tools of choice: CruiseControl.Net, Subversion, NUnit, NCover, and MSBuild. Originally, I ......
I have started on a new project and am looking forward to implementing continuous integration (CI). There are quite a few decisions that need to be made as far as how we want to handle the build and deployment process. I am working with a small group of people who have worked together in the past. They have some practices that have worked well for them. I don't want to rock the boat too much, so I am evaluating their process with what I know and am familiar with myself. The biggest difference between ......