How to pass null for a parameter in stored procedure - the parameter is uniqueidentifier

Posted by jess on Stack Overflow See other posts from Stack Overflow or by jess
Published on 2010-03-22T07:16:33Z Indexed on 2010/03/22 7:21 UTC
Read the original article Hit count: 510

Filed under:

nullable

In C# code I have a variable Guid? name.But,how to initialize this parameter to null,since I cannot assign null for a guid type

Related posts about nullable

Nullable Type implementation without nullable feature of C#

as seen on Stack Overflow - Search for 'Stack Overflow'
How can we implement a nullable type in C# if we didn't have this feature in C#? >>> More
Nullable Enum nullable type question

as seen on Stack Overflow - Search for 'Stack Overflow'
I get the following compilation error with the following source code: Compilation Error: Type of conditional expression cannot be determined because there is no implicit conversion between '' and 'MyEnum' Source Code public enum MyEnum { Value1, Value2, Value3 } public class MyClass { … >>> More
Order by nullable property simultaneously with ordering by not nullable property in HQL

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi, I have a table called Users in my database. Let's assume that User has only 3 properties int ID; string? Name; string Login; If user doesn't specify his name then Login is displayed. Otherwise Name is displayed. I wan't to get list of all users sorted by what is displayed. So if user specified… >>> More
Nullable ToString()

as seen on Stack Overflow - Search for 'Stack Overflow'
I see everywhere constructions like: int? myVar = null; string test = myVar.HasValue ? myVar.Value.ToString() : string.Empty; Why not use simply: string test = myVar.ToString(); Isn't that exactly the same ? At least Reflector says that: public override string ToString() { if (!this… >>> More
LINQ-to-SQL IN/Contains() for Nullable<T>

as seen on Stack Overflow - Search for 'Stack Overflow'
I want to generate this SQL statement in LINQ: select * from Foo where Value in ( 1, 2, 3 ) The tricky bit seems to be that Value is a column that allows nulls. The equivalent LINQ code would seem to be: IEnumerable<Foo> foos = MyDataContext.Foos; IEnumerable<int> values = GetMyValues(); var… >>> More

Developer IT

How to pass null for a parameter in stored procedure - the parameter is uniqueidentifier - Developer IT

How to pass null for a parameter in stored procedure - the parameter is uniqueidentifier

nullable

Related posts about nullable

Nullable Type implementation without nullable feature of C#

Nullable Enum nullable type question

Order by nullable property simultaneously with ordering by not nullable property in HQL

Nullable ToString()

LINQ-to-SQL IN/Contains() for Nullable<T>

Categories cloud