Some people have work to do, and can't afford much time to hang about reading silly questions. What time I do have I prefer to use wisely.

What time's the next bus?

There's far too many silly questions appearing on this forum, like 'Please write my project for me'. This place used to be the best forum around, and the first place I would turn to, but trying to wade through all these inane questions is just too much. Has anyone got any ideas as to where I can go with a more erudite audience?

Thanks to everyone who answered my plea. - I've since found out that the meeting on the second Tuesday of the month is purely at one persons discretion, so I've decided to let that person enter the day on the timetable themselves. Thanks again, your answers were most appreciated.

Entity framework connects to SQLIte easily.

This is a weird one from a client. I've been racking my brains on how to do this, but as yet, no success. Starting from a random date, to another random date (school term dates), how can I flag up the second Tuesday of each calendar month? I will accept hoots and jeers :laugh:

This seems to be a general trend in this forum, (or is it just me?). There seems to be a plethora of entries from people with names like 'member xxxxxxx' where xxxxxx is a big number, asking for programmes to be written for them, usually written in bad english. What's going on here?

Oh right, one of them. That'll be in .NET 3.Silly won't it?

what's a widget?

Thanks Griff, you've put into words exactly what I wanted to hear. there's about 50 teachers, and it's remotely possible that they will all be entering results at the same time. Taking your advice, I've decided to use SQL server. The project will be on separate laptops, each with 8Gb of memory (don't you just love school standardisation?), so downloading all the data at run time won't be a problem, and I will have a trigger to flag updates. Not quite figured out how to do that yet, but I'm sure it can be done. I'm going to use Entity Framework, as my data layer, with the business and presentation layers separated as well. In fact the only problem I can see is convincing the management team that the data is actually secure, even though it is on a remote server.

I’m writing an exam management program for a high school, using a remote SQL Server database. In the project, I access the database quite often, to get lists of student names, subjects, sets etc. The student (about 2200 records), Teacher (about 50 records) and subject (20 records) tables contents change very infrequently, I was wondering: 1. Would it be more efficient to read these tables at program start, and retain the information as lists in memory, or should I read each table whenever the user needs it (possibly five times per session)? 2. Is SQL Server 2012 overkill for this project? I’ve thought about using SQLite in a local database, but for the life of me, I cannot get it to work. (This is the problem of working by myself, I’ve no-one to bounce ideas off). 3. Do any of you boffins have any better suggestions as to how to go about this? I’m putting this in the C# forum, as that’s the language the database will be accessed from, but if you think that it should be in the database forum, please feel free to move it. (Or tell me and I’ll re-write it there).

It's not a big project by any stretch, but it's one of those that has the capability of growing. I've written the same kind of thing lots of times before. There's just one (new) bit I'm unsure of, and that's a legal requirement to identify sellers (The New Zealand second hand dealers act is quite rigid on that), but I'm sure I'll find a way to do it.

Thanks for the reference, I'll have a good look at it this morning.

I've taken that into account, I think I'm going to do the project in both, Window Forms and WPF. That way, I'll only bill for the forms development (I can write it in my sleep anyway, there's nothing earth shattering about it).

Sorry, should have checked first. Mea Culpa.

As an honest trader, I'll only bill for what he gets. There's a lot of cowboys out there that don't, And this is in the wop-wops where clients rapidly become friends.

I've taken on a small project, to write a client/purchase/sales register for an antiques/second-hand shop. The client wants a software suite that will answer some unique questions to his business, and having looked round at off the shelf software he decided that he needs a package written just for him. It will only be for his use, and not for eCommerce. That might come later, but it's not definite. I've written lots of packages like this, in VB6 and for the past five years in C#, but I'm beginning to think that I might step out of my safety zone and try to write it in WPF. However, I have no experience whatsoever in this, and would welcome any advice you can give me. Thanks in advance, George

I've found what I've been doing wrong Dave. When I've been adding the Entity Data model when I started the project, I've been deleting the two .tt template files and setting the code generation strategy in the edmx properties to 'default'. This hasn't been generating the (correct) code to use dBSet. I've still got a lot to learn yet about this, as it's opened a few more cans of worms for me, (For example, what happened to my 'AddObject' methods?) This highlights my original point. I'm a freelance developer, and have been for about 10 years now. I work by myself, and I have no-one to bounce ideas off, or show me my mistakes. I learnt EF by buying Julia Lerman's book and studying enough of it to get my current project up and running, but not going any further. When I worked for a software house in England, I used to dread code review day, but I can see now how useful it was. I know I'm still missing a lot, and I would be grateful if you could point me to a good tutorial about the correct way to deal with Entity Framework, and .tt files and all. Thanks for all your patience Dave, it's been much appreciated. George

I started a new project to test the find method, and I'm still getting the problem. My app.config looks like this:

The System.Data.Entity DLL reports as being version 4.0. I downloaded a version 5.0 of this DLL, but even that reports as version 4.0

No, I started a new project to test the find method, before I used it in one of my operational ones. My app.config looks like this:

but the version of Sysytem.Data.Entity.Dll reports back as being version 4. I've downloaded a version 5 of this DLL, but even that r4ports that it's version 4.0