This is technically not a problem or issue with entity framework, but since i am using EF as my means to envoke the stored procedure I thought it would be best to post this question here.
I created a test table that has two columns:
CREATE TABLE [db_owner].[DATETIME_TEST_TABLE](
[ID] [bigint] IDENTITY(1,1) NOT NULL,
[DATE_COLUMN] [datetime] NULL
) ON [PRIMARY]
I have a page that contains a textbox and an ajax control toolkit ?CalendarExtender that will allow the user to select a date from the calendar. Actually there are 30 or so of these on the page, but if i can get the desired behavior for one I will have it for all of them.
What happens next is that on a button click event, i am firing the below stored procedure via EF:
ALTER PROCEDURE [db_owner].[sp_CSD_Insert_Dates_TEST]
SET NOCOUNT ON;
Insert into db_owner.DATETIME_TEST_TABLE (
I have imported the stored procedure into my edmx data model and created a function import from this stored procedure. Here is the EF autogenerated function import:
Public Function CSD_INSERT_DATES_TEST(pDate As Nullable(Of Global.System.DateTime)) As Integer
Dim pDateParameter As ObjectParameter
View Complete Post