Click here to Skip to main content
15,902,874 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
Table:
SQL
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[EMPDATA](
    [ID] [numeric](18, 0) IDENTITY(1,1) NOT NULL,
    [ENAME] [varchar](50) NULL DEFAULT (''),
    [EADDRESS] [varchar](200) NULL DEFAULT (''),
    [ETELNO] [varchar](20) NULL DEFAULT (''),
PRIMARY KEY CLUSTERED
(
    [ID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF


Procedure:
SQL
alter proc selection
as
select id, eaddress from empdata
select ename,eaddress from empdata
select eaddress,etelno from empdata
exec selection

select * from empdata

Please give solution that how can i code in .dbml file to acess these table in vb file and asign then to tables.


[Edit: KBarrow] Fixed formatting
Posted
Updated 17-Jul-11 3:10am
v2

The simplest way is to use ObjectContext.ExecuteStoreQuery[^]

Best regards
Espen Harlinn
 
Share this answer
 
Comments
thatraja 17-Jul-11 10:58am    
I was confused at first & then realized it's a new one(.NET 4.0 which I never worked on :sigh:)
5!
Espen Harlinn 17-Jul-11 11:04am    
If you can't avoid EF, it's a "must know about" kind of thing :)
Found this[^] to be a useful tutorial.
 
Share this answer
 
Comments
thatraja 17-Jul-11 10:59am    
Nice tutorial, 5!
Abhinav S 17-Jul-11 11:01am    
Thank you buddy.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900