How do I create queries to SQL Server tables via Visual Studio when no knowledge about SQL nor Linq?

Let´s be frank, my knowledge regarding SQL language is very low.

Nevertheless, my boss gave me the task to build a database application using the following tools: SQL Server and Visual Studio 2008; C#. I use the VS DataSet as a local mirror of the SQL Server.

And let´s be frank again, my understanding of the VS Query builder is also very small, I´m finding it quite confusing, actually. So no help to find from Query builder.

And my knowledge of Linq is even lower...

Perhaps I should mention that the deadline for the project is "aggressively" set, so I have no chance to learn enough about these things during the project. And I´m a bit stupid too, which is no help when it comes to challenges like this (on other occations it might be quite useful though)

With these permissions, what should I do 开发者_Python百科(except for killing myself or retire) to be able to query my tables in a sufficient way?

Start learning. Look for another job at the same time. Obviously your boss is an idiot - giving you tasks to be not qualified for (or the story is a little different - would not be the first "specialist" trying to find employment that is clueless).

Sorry, I really dont know what else to say here - if yo do not know how to do your job, learn. If that does not work, then you can not do your task. Simple like that.

SQL Query takes a day to get started (on a beginner level). If you do not have this time - get your boss hire someone who has the knowledge.

keep a c# reference book handy. Also a book on sql or you can use sql books online. You can always google for your specific problem or use a forum to get answers. Be optimistic, quit whining and get to your task. All the best.

what type of task you want to do in SQL ? define in Detail. and start working on the sql it's easy to understand.

there is a visual query designer in visual studio. that might be helpful. Open up server explorer, right click and existing database connection or create a new one and then right click to select 'New Query'.

In the query designer, you can add table and visually add conditions for joins, aggregates etc. and see the query being formed.

Use MS Access:

1. Start up Access, create a new DB.

2. Import your SQL Server DB to your new Access DB.

3. Select Create tab -> Query Wizard -> Simple Query Wizard (and it IS simple to use).

4. When the query is created, you can use the SQL code in your original SQL Server based application - but as SQL Server and Access aren´t 100% aligned, you might need to do some adjustments - google it up. Here is however a good page that will help you out.

Bonus is that it´s a good way to learn SQL "on the fly".