Search:

If you need a Document database (NoSQL), I would chose MongoDB over RavenDB, besides MongoDB is free.

You can also do a straight through IMPORT into SQL Server. Select Access as your source. Then write a t-sql script to change each table to use identity. You can query sys.tables, loop through them...

The reason a lot of people are having a tough time moving from VB6 to .NET is because VB6 (and early) was never an object oriented language, more like Object Based. VB6 has lots of static function...

You can try to use body.onblur event and do a location.href = '/account/logoff' (but it will not work 100%). Also you can specify a small timeout in your web.config (default is 30 minutes).

...

My personal view on EF is that if my application has many concurrent users, I would never ever use EF. It's the slowest framework there is. Although MS has optimized it a bit in 4.5, its still slow...

You should assign a function call in your A tag, then change location.href to your ActionResult. Do not use void. You don't have to use an HTML helper because you don't really need your URL to go...

Or you can just execute a dynamic sql passing your variable with "IN" values.

Run a SQL Server PROFILE and monitor your sql statements. Navigate to the page/form where you expect to have that SP to run, check back in the profiler which SP was ran.

You can accomplish it in 2 ways:

1. Export data to SQL Server and then manually change the NUMBER field to include identity.
2. Create a table that already defines that field as identity, enable...

The reason it worked with a ViewBag is because you explicitly assigned value to it.
This code:


var viewModel = db.stp_getEmployees(0, 1, null, "", "[Name]");
ViewBag.Employees =...

You cannot copy those 2 files while the database is attached and live. SQL Server has it's own format to store both database and the log in 1 file (unless you want it in .sql file as an export).

I can tell you first hand about NoSQL database as I'm using it in conjunction with SQL Server. NoSQL is not a solution for ALL scenarios, there are pros and cons. I personally use MongoDB but there...

You can't launch Excel from ASP.NET because the file will be opened on the SERVER and not your computer. What you can do is process the file and serve it for the client to download it.

It's because if you look at your code, your empList is never being populated with records. I'm not sure what you are using for your data access layer (LinqToSQL, Entity Framework, pure ADO.NET or...

What are the problems are you having with IE10?

The code you have should work. All you have to do is "return View(empList )"; at the end of your ActionResult. Just make sure you define your model (in the view) as List<EmployeeInfo>.

In your...

Another thing to think about is your transaction log. If you insert 2mil records in a loop your transaction log file gets bigger and bigger. The bigger the transaction log file, the slower the...

If you've ever done it in MVC without stored procedure than you already should know the answer. Using stored procedure in opposed to dynamic sql statement (or ORM if you are using one) doesn't make...

I don't think .NET is going anywhere. If there is anything, it's expanding. VB6 (and I used to love it) should go away. It doesn't serve that much anymore. It's lacking a lot of programming...

If you don't mind getting "somewhat old" data, you can use NOLOCK to do "dirty reads".

SELECT Field1,Field2 FROM Table(nolock)

You might not get all the data. When the first portion is being...

If you are searching for partial names for example (or any other text-like keywords), this query:
select * from mytable where lastname like 'Abc%' will not use an index and the query on a couple of...

Sorry to be blunt but this quiz is irrelevant.


It doesn't provide even a partial scope of C#.
C# is not only used to create WINDOWS applications.
There were a couple of questions related...

That error indicates that the float might not have enough to store the value. It is not a problem with varchar. Use double instead of float (in you cast statement).

You can read Request.Files in your ActionResult. It's pretty easy to do.

I would second this except the indexes. I would add all indexes(except PK) afterwards. I always do that because most of the time I move a lot of data and populating a table with lots of data is slow....

Have you tested the stored proc itself (in sql server management studio)? Does it return data?

Relational database doesn't really scale horizontally. So you can either use RAID5/10/50/60 of multiple drives or deal with the drive size later. If you don't need transactions then I would even...

There are many ways of doing that.

You can link an oracle server/db in the SQL Server then do a select from the linked server and insert into sql server table(s).
You can import the data...

It depends how the data is stored. If the data represents a little-endian 64-bit integer, then you can convert it like this:


public DateTime HexToUTCDate(string hex)
{
//Convert Hex To...

Looks like you forgot one parenthesis:

Change this:
var target = $this).attr("id");

to this
var target = $(this).attr("id");

I understand your reasons but until you get those arrays loaded the user will just sit there and wait. Although it might take a couple of seconds and you might only get one array of 25k records to...

That goes against all rules in web page development. Your initial load will be slow(er). Also if you have a public website, you will be heavily penalized by search engines. Your rank is also based on...

I've used autocomplete with 500k user records (ajax calls). With proper indexes in the table, it works very well even if you set minChars: 1.

http://www.codeproject.com/Articles/50056/Read-M4A-tags-in-C

1. You can actually use MVC's routing to redirect from one project to another but this method could be problematic if you have many link types to work with.
2. You can just merge 2 projects into 1...

Even if you create your own custom membership provider, you shouldn't use USERS table to store extra fields. You can either implement your own custom PROFILE provider (as I did) or just use a built...

Your query looks pretty simple (although it's not recommended to just concatenate strings to your WHERE clause, as it opens your application for SQL Injections, use parametrized query instead ). But...

First thing first, you cannot store your IEnumerable values in the hidden box.

Question, are you trying to do the update call through Ajax? If that's the case you will have to store your...

Actually ActionFilters CAN work both on the class level as well as on an individual ActionResult. As long as you don't decorate your ActionFilter with definition to ONLY allow it on the class level....

The only way I know is to call ExecuteStoreCommand on the ObjectContext object.

objectContext.ExecuteStoreCommand
And I believe this code will only work in EntityFramework 4.0.
...