Tagged Questions

1
vote
1answer
55 views

Receiving null value error when providing a value to SQL Server table

I am receiving the following error when trying to perform an insert: Cannot insert the value NULL into column 'Request_Cat_ID', table 'dbo.Request_Categories'; column does not allow nulls. INSERT ...
0
votes
1answer
43 views

How can I auto-update the int ModifiedBy property on a Entity with UserId in Entity Framework 4 when saving?

I am using Simple Membership and a UserProfile table that maintains UserId and UserName: public partial class UserProfile { public UserProfile() { this.webpages_Roles ...
0
votes
2answers
64 views

How can I create a database in SQL Server by code first entity framework 6?

I have an ASP.NET MVC project in VS 2012. I want to use Entity Framework 6 code-first. When I create model and db-context file and when I run my project it does not create any database in my SQK ...
1
vote
2answers
73 views

Convert Html 5 img src data sting into Raw bytes or File

I would like to store the HTML 5 image src bytes into DB as binary or in a HardDisk. Later I want to read and assign it to img src="url" Here is the HTML 5 code <img ...
0
votes
2answers
17 views

1 to 2 mb XML file in MSSQL or Filesystem / Size based storing criteria for XML files

I have xml files which I am trying to decide whether to save on Filesystem or SQL the file size varies from 1MB to 2MB. Can sql handle a single record of such size? Also can anyone make a guide of ...
0
votes
1answer
53 views

Insert a business opening hours with mvc

I need to insert a business opening hours schedule from monday to sunday, including the open/closing hour and lunch open/closing hour. I also need to specify if the business is open this day, and of ...
0
votes
1answer
89 views

Web API controller for uploading a file on the server and save it in my sql server database

I know how to upload a file and save it on the server as a physical file. I have successfully implemented this solution, there are lots of examples on the net. Now I am searching for uploading a file ...
0
votes
1answer
32 views

DB's long-live connections or on-demand connections?

I was assigned to implement an application (in C++) to evaluate pending submissions (a submission is a programming algorithm to a given problem). A site (in ASP.NET MVC) posts problems and allows the ...
0
votes
1answer
22 views

Multiple MVC 4 Web Applications in the same Windows 2008 R2 Server

Can I have multiple environments of the same MVC4 Web application in the same Windows 2008 R2 Web Edition server? I would like to have: QA (Quality/Pre-production) environment - SQL-Server Database ...
0
votes
0answers
45 views

Entity Framework - Mapping many to many when no relationship is defined in the database

I'm new to Entity Framework and trying to implement the following scenario: Existing database, which contains a type of contacts and organisations table. It looks something like (very simplified): ...
0
votes
2answers
46 views

Connectionstring to mdf file

I've created this MVC4 web application and went with a local MDF (localdb?). It's located in the \App_Data folder of my project. It's name is SiteDatabase.mdf. But right now im struggling with the ...
0
votes
2answers
46 views

Getting error “The user instance login flag is not supported on this version of SQL Server.” but not using this flag

I recently upgraded a SQL Server Express database I was using locally to SQL Server 2012 Developer. I started getting this error. A quick search pulls up tons of posts where the answer seems to be to ...
0
votes
0answers
25 views

provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified No fix?

I recently added a second site to my server. That site gives me the dreaded: System.Data.SqlClient.SqlException: A network-related or instance-specific error occurred while establishing a ...
0
votes
0answers
42 views

Cannot materialize complex or primitive type - WCF Data services

i use WCF Data services along with Entity framework to talk to the SQL Server database. The data is not directly accessed through the ORM but instead ,the stored procedures are used to fetch and ...
-1
votes
0answers
39 views

Search engine, asp.net mvc 4, SQL Server 2008

I have a big database in SQL Server 2008. Now I want to develop a search engine for that database. I want to do it in VS2012 (Asp.net MVC) using Entity Framework. I am confused how and what to ...

1 2 3 4 5 … 40
15 30 50 per page