LINQ to SQL technology question

[BunBo900]

Hello -

I need to make some changes to the existing web app. This web app is written in C# using LINQ to SQL
technology. I am a newbie to C#; the new requirements seem to be obvious to understand. But did not work as I expected to be.

My question is for this technology when make a change to a query do I need to compile it into a dll file? because there are a few dll files involve and I am not sure how to compile into a dll or do I need to.

I have been reading on this technology but not quite get it yet.


Please advice,

Thank you.

 

[tcsbiz]

I use LINQ to SQL call ing stored procedures. If I make a change to a procedure, I always delete it from the LINQ work area and add it back in. I then build the project, then publish it.

I am using VB building web applications, not websites.

 

[BunBo900]

Do you deal with query in your app? what do you mean by saying 'LINQ work area'? Is it the same as 'LINQ to SQL designer'?

thank you.

 

[Qik3Coder]

The effort required depends on how intense your change is.

Is the query in LINQ in web code or is it in a stored procedure in the database?

If sproc:
If you are adding/removing a parameter/output column, then you will need to modify your web code. Otherwise the code doesnt know any different and you just deploy the new sproc.

If in line LINQ-SQL:
then you have to recompile and deploy the relevent dlls.


Lodlaiden

A lack of experience doesn't prevent you from doing a good job.

 

[BunBo900]

It is in line LINQ-SQL:

If I only make a change to the code behind page, do I still need to recompile to the page?

 

[Qik3Coder]

Yes.
The code behinds get compiled into a .dll (normally)

A lack of experience doesn't prevent you from doing a good job.

 

[BunBo900]

Is this how you compile code behinds into dll?

Open the code behinds page in VS studio -> hit F5? Doesn't seem right to me.

Please give me instructions.

Thank you.