All Questions
Tagged with sql-server linq
8 questions
5
votes
1
answer
767
views
Are legacy C# DataTable/SqlDataAdapters exponentially faster than SqlConnection/SqlCommand and/or LINQ to SQL DataContext.ExecuteCommand calls? [closed]
I can't believe DataTable/SqlDataAdapter massively beat out System.Data.Linq.DataContext.ExecuteCommand and ExecuteNonQuery (tried with both Stored Procedures and command text) and just straight ...
- 159
0
votes
0
answers
2k
views
.NET WPF Best way to store a connection credential
I have an application that connects to SQL Server using windows credentials, which works very well for the domain paradigm. The client is now transitioning away from having a domain server, and is ...
- 115
0
votes
1
answer
934
views
Create an item in two different table with auto-increment C# SQL [closed]
First of all, let me apologize because I know my question will be very confusing since my English is pretty bad.
I am working on a project for a company, mainly create a system to take care for ...
user201378
1
vote
1
answer
1k
views
Portable Data in C# App
I have developed a C# front end app for management of an SQL Database for the purposes of document control. The project this database is for has several consultants and a client spread in a variety ...
- 115
0
votes
1
answer
1k
views
Simplifying data search using .NET
An example on the asp.net site has an example of using Linq to create a search feature on a Music album site using MVC. The code looks like this -
public ActionResult Index(string movieGenre, string ...
- 135
3
votes
1
answer
928
views
Is it okay to convert dataset from stored procedure to IEnumerable
So, I am working on a project with a team and we are using Entity Framework. We basically want to use linq to entities, and not use stored procedures. I use quite a bit of lists and IEnumerables and ...
- 279
2
votes
4
answers
2k
views
What is the most effective order to learn SQL Server, LINQ, and Entity Framework?
I am trying to get some advice on what order I should learn about SQL Server, LINQ, and Entity Framework to be able to better work with ASP.NET Webforms and MVC.
From what I've been able to learn so ...
- 349
0
votes
1
answer
295
views
Comparing features in a asp.net web application using different database methodologies [closed]
I have a webstore which sells components (it is a academic project) which looks like this. I have developed the same web application using following database methodologies:
MS Sql Server with Stored ...
