Click here to Skip to main content
14,983,711 members
Home / Discussions / Database
   

Database

 
Questionset password on database in sql server 2005 Pin
SajjadZare21-Jul-11 22:11
MemberSajjadZare21-Jul-11 22:11 
AnswerRe: set password on database in sql server 2005 Pin
Blue_Boy21-Jul-11 22:24
MemberBlue_Boy21-Jul-11 22:24 
JokeRe: set password on database in sql server 2005 Pin
lw@zi 21-Jul-11 22:27
professional lw@zi 21-Jul-11 22:27 
JokeRe: set password on database in sql server 2005 Pin
Blue_Boy21-Jul-11 22:28
MemberBlue_Boy21-Jul-11 22:28 
GeneralRe: set password on database in sql server 2005 Pin
SajjadZare22-Jul-11 0:24
MemberSajjadZare22-Jul-11 0:24 
GeneralRe: set password on database in sql server 2005 Pin
Blue_Boy22-Jul-11 2:56
MemberBlue_Boy22-Jul-11 2:56 
AnswerRe: set password on database in sql server 2005 Pin
Shameel22-Jul-11 9:19
professionalShameel22-Jul-11 9:19 
QuestionEntity Framework and Default Values [answered] Pin
Pascal Ganaye21-Jul-11 6:33
MemberPascal Ganaye21-Jul-11 6:33 
I setup a simple sample program to expose a problem I have with the EntityFramework.

A simple table contains 3 fields
contactguid UNIQUEIDENTIFIER Default: NEWID()
surname     VARCHAR(255)
forename    VARCHAR(255)


I have created an EntityFramework model for it and wrote this code
policy = dbContext.CreateObject<tblContact>();
policyHolder.Surname = "Blog";
policyHolder.Forename = "Joe";
dbContext.SaveChanges();

The issue is that whatever I do the query set to the database will look like this:
exec sp_executesql N'insert [dbo].[tblContact]([ContactGUID], [Surname], [Forename])
values ('00000000-0000-0000-0000-000000000000', 'Blog', 'Joe')

I was not expecting the ContactGUID to be set with zeros but the default NEWID() to be returned to the client.
This is not happening.
I have tried to change about every property of the contactguid field (particularly StoreGeneratedPattern) but nothing seems to have any action.
Did someone hit this problem?

modified on Friday, July 22, 2011 4:39 AM

AnswerRe: Entity Framework and Default Values [answer] Pin
Pascal Ganaye21-Jul-11 22:05
MemberPascal Ganaye21-Jul-11 22:05 
QuestionHow to do a select statement from two or more tables? Pin
eight20-Jul-11 23:27
Membereight20-Jul-11 23:27 
AnswerRe: How to do a select statement from two or more tables? Pin
Blue_Boy20-Jul-11 23:43
MemberBlue_Boy20-Jul-11 23:43 
GeneralRe: How to do a select statement from two or more tables? Pin
eight20-Jul-11 23:51
Membereight20-Jul-11 23:51 
GeneralRe: How to do a select statement from two or more tables? Pin
Blue_Boy21-Jul-11 0:58
MemberBlue_Boy21-Jul-11 0:58 
AnswerRe: How to do a select statement from two or more tables? Pin
Niladri_Biswas24-Jul-11 22:26
MemberNiladri_Biswas24-Jul-11 22:26 
General:-\ Select Pin
velmahesh20-Jul-11 18:22
Membervelmahesh20-Jul-11 18:22 
AnswerRe: What is Buffer Pool in SqlServer? Pin
Mycroft Holmes20-Jul-11 20:51
professionalMycroft Holmes20-Jul-11 20:51 
AnswerRe: What is Buffer Pool in SqlServer? Pin
Blue_Boy20-Jul-11 21:25
MemberBlue_Boy20-Jul-11 21:25 
GeneralRe: What is Buffer Pool in SqlServer? Pin
Shameel21-Jul-11 2:29
professionalShameel21-Jul-11 2:29 
GeneralRe: What is Buffer Pool in SqlServer? Pin
Blue_Boy21-Jul-11 2:44
MemberBlue_Boy21-Jul-11 2:44 
AnswerRe: What is Buffer Pool in SqlServer? Pin
PIEBALDconsult21-Jul-11 2:45
professionalPIEBALDconsult21-Jul-11 2:45 
QuestionSSRS 2005 Sub report issue (newbie) Pin
Paul E Davies19-Jul-11 1:07
MemberPaul E Davies19-Jul-11 1:07 
AnswerRe: SSRS 2005 Sub report issue (newbie) Pin
Paul E Davies21-Jul-11 0:27
MemberPaul E Davies21-Jul-11 0:27 
QuestionSQL Syntax Issue Pin
Frank Lepkowski18-Jul-11 3:04
MemberFrank Lepkowski18-Jul-11 3:04 
AnswerRe: SQL Syntax Issue Pin
Tim Carmichael18-Jul-11 3:13
MemberTim Carmichael18-Jul-11 3:13 
AnswerRe: SQL Syntax Issue Pin
AnnieMacD18-Jul-11 3:38
MemberAnnieMacD18-Jul-11 3:38 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.