using SQL server express 2012 with LINQ in C#

Question

1.00/5 (1 vote)

See more:

Hey guys, first post on here.

I have been commissioned to create some software for my boss, a couple which use databases, sql, phones etc. So i have a list of things, and I would like to know if it's all doable in C#. I am currently learning the language and LINQ, have sql server 2012 express installed, and a damn fine learning attitude to boot, so please, go easy :)

Here is my list:

1. A logging software, that utilises a database to create reports for clients, logging incidents and numbers of people out of certain areas, so we know how many people are on site at one time

2. A check calling system, so we can check when guards are checking in. This will use a dedicated automated phone number where the guard calls and enters their pin number, then it shows up on the computer if a guard has or hasnt checked in by a certain time

3. A rota system, to keep all staff rotas on, using a database to contain the sites, staff etc

4. A database for keeping staff details, records, audits, interviews, meeting notes, like a storage system where one staff member will have several documents and types of files associated

Any way someone can help would be massively appreciated. Alsi, if you wouldnt mind, would you tell me what i would need to know or how i would go about getting started for each project, obciously i expect to do the learning and work on my own, but a point in the right direction (you would need this to set up an automated phone line to the software etc) would be a massive help.

Thanks guys!
Anthony

Posted 1-Oct-13 10:02am

brucey_D

Add a Solution

Comments

bbirajdar 1-Oct-13 23:47pm

Did you notice that this is a quick answers section and your question can be answered in this particular section ?

brucey_D 2-Oct-13 0:21am

sorry, im new to this site, how do i migrate it?

bbirajdar 2-Oct-13 1:09am

Not required. You have dumped the abstract requirements of four projects here. Nobody has time enough to explain those to you. If you would have checked the other questions in this section, you can see those are specific questions - not projects requirements. And before somebody answers you , you should show what you have tried..

In your case, its better for you to start with Google first.

Also do care to read this link http://mattgemmell.com/2008/12/08/what-have-you-tried/

brucey_D 2-Oct-13 1:47am

Did you read the question? I simply want to know what i would need to learn to complete the above??

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

MK-Gii · Answer 1 · 2013-10-01T21:25:00

Hello Brucey,

1. Question is not quiet clear... but... If I understood your question correct - you got SQL server somewhere in the middle of nowhere and you want to do some reporting from it.
In this case you should do the following:
1.1 Create SQlConnection and open it (more info here:
http://msdn.microsoft.com/en-us/library/system.data.sqlclient.sqlconnection.aspx[^]
1.2 Open that connection and create a data reader to read data which is required for your reporting. More info here:
http://msdn.microsoft.com/en-us/library/system.data.sqlclient.sqldatareader.aspx[^]
I had very similar tasks before so I read all data to generic List<t> and then with LINQ I filtered and created anotherone which I moved into Excel for presentationla purpose.
More about how to do it here:
http://msdn.microsoft.com/en-us/library/microsoft.office.interop.excel.aspx[^]

2. Question again not clear - not clear what you have and therefore not clear which is the best way to go.
But if you have all data flowing into SQL Server - then try doing it with a triggers. More about triggers here:
http://msdn.microsoft.com/en-us/library/microsoft.office.interop.excel.aspx[^]

3. No idea what the question is about. Sorry ;]

4. A database? I thought you have an SQL Server...

Cheers!

Modestas.

P.S.: With all respect mate - please ask detailed questions as I doubt that there are many people keen on babysitting :)