I'm executing an update stored procedure from LINQ to SQL and I need to know the records affected after the update is called. I'm using dbml designer to generate the LINQ code.
View 4 Repliesi have create the object of
1 dataclassContext obj=new dataclassContext();
2 now i call the updateProc
int row=ob.MyupdateProc(QuestionID,peronID);
if(row>0)
{
do some thing
}
but row always retrun 0 even procdure do update in database
When i click the reset button, the password is updating in the table.
i.e.,
update UM_USER set password='ahlnhTczpihljbIn', exp_date='01/JAN/2008' , max_sessions=3
How to write the stored procedure and call the procedure in .Net coding?
The codes are below:
[Code]....
I get the fol error: An exception of type 'System.Data.SqlClient.SqlException' Occurred in System.Data.dll but was not handled in user code..Subquery returned more than 1 value. This is not permitted When the subquery Follows =,! =, <, <=,>,> = Or When the subquery is used as an expression.
IF EXISTS (SELECT CustomerId FROM Customers where CustomerId= (SELECT Id FROM @tblCustomers ))
UPDATE Customers
SET Name=(SELECT Name FROM @tblCustomers ), Country=(SELECT Country FROM @tblCustomers )
WHERE CustomerId=(SELECT Id FROM @tblCustomers );
Else
[code]...
I have a table and i want to use this table in asp.net page
how i will call the stored procedure on the basis
of Stored procedure's Action .
Â
CREATE TABLE Std_Enquiry(
StdID int IDENTITY(1,1) PRIMARY KEY CLUSTERED ,
FirstName varchar(50) ,
LastName varchar(50) ,
[Code].....
I have created a viewmodel class for my custom page. I have a stored procedure which returns the DataTable(ORM tool). I cannot change this procedure. But I would like display the records from the stored procedure on View List. How can I display the values from the datatable in the List View?
public class CreateViewModel
{
[Required]
public DateTime StartDate {get; set;}
[Required]
[StringLength(250, ErrorMessage = "Details must be less than 250 characters")]
public string Details { get; set; }
}
I am trying to re-write an existing asp.net website using MVC with Linq to SQL. A page we have is used to insert new contracts and uses usp_contract_insert to insert a new contract into t_contract as well as t_project. On my dbml file i have dragged t_contract on and then I try to drag usp_contract_insert on top of that and I get the error :- Microsoft Visual Studio
One or more selected database objects return a schema that does not match the schema of the target data class. Nothing has been added to the designer. The stored procedure returns the id of the last project which was inserted. I don't quite follow this and unsure how to go about hooking my Controller up using Linq to SQL to call this stored procedure
I am using LINQ to SQL for inserting, updating my DB now i am using stored procedures to do the same,but i dint find any advantages or less code in using stored proc what is the main diff between using stored proc and not using stored proc?
View 1 RepliesI am inserting records using stored procedures in LINQ to SQL but i am getting an error at empid
[Code]....
i am getting error like Table 'emp' does not have the identity property. Cannot perform SET operation.how to solve this??
i have a stored procedure i want to display the income of this procedure in a HTML table ona aspx page. It that possible.
[code]....
I am trying to execute a stored procedure in LINQ. When run in SQL Server it returns several fields, mostly integer and float fields. But when I call the stored procedure in LINQ, all it returns is 0. Here is how I am calling the stored procedure :
[Code]....
And here is the stored procedure :
[Code]....
I am new to Linq server.I have a stored procedure in my databse that retuens count number.
select COUNT(*) from tbl_WorkerUsers
where WorkerCode=@Wcode
when I run it directly in my database it returns 1.
exec checkWorkerCodeAvailibility 100000312
but when I run it in c# code it always returns null.
WorkerDataContext Wkc = new WorkerDataContext();
int? result = Wkc.checkWorkerCodeAvailibility(Int32.Parse(Wcode)).Single().Column1;
i am using stored proc in linq to sql but i have done insert & delete operations but im unable to do the select operation i have tried but no use,whenever i enter the id into the textbox it should display the record?
View 5 RepliesI am inserting records using stored procedures in LINQ to SQL in MVC.but i don't know the proper way.
View 1 RepliesI need to be able to delete records from a gridview using a stored procedure. My data comes from two sources so the standard delete won't work. I have come up with the code below which deletes a record, but the wrong one. How can I iterate through the rows to delete the row I actually want to delete.
[Code]....
I have function like
Public Dataset getdata() {
dataset = db.prcGetdata("name");
return dataset; }
db is linq. prcGetdata is a proc which accepts name param and returns 1 or more rows. So, my requirement is how to get data to dataset using linq.
I am working on LINQ. I am calling a SQL Stored Procedure with 2-3 parameters it's working fine. When i am going to call Stored Procedure with 8 to 9 parameters the auto generated column is not comming automatically. So i am unable to use LINQ with Stored Procedure with multiple parameters.
View 4 RepliesI have created one stored Procedure as
[code]...
I am not getting the result with extra column c.I am not getting what is the Problem.In sql server,It's working fine.
Is it posible to run a stored procedure using linq? I dont mean one that returns a table i just mean one that runs a set of transactions exec sp_MyProc @Var or something?
View 1 RepliesI have two tables dept and employees those table have parent and child relation ship link column is deptno i want to delte department even this departmetn contains employees i want to write storedprocedure for first delte employees and after department if i wrtie these two querys in storedprocedure will i get any problems
Begin
Delete from tbl_employees where Department_Id=@Department_Id
Delete from tbl_Department where Department_Id=@Department_Id
RETURN
END
i do have a stored procedure which inserts data and the message should be displayed that data has been sucessfully updated or not
[code]....
Using asp.net MVC in c#, I am making a call to a stored procedure using Linq into my SQL Members table. I have no internal caching on the application, already checked to make sure it is turned off.
Test case:I have my username set to test1. From the website I change my username to test2. The website still shows test1. I go to Management Studio and run my stored procedure called MemberByEmail, it shows test2 correctly.I start simple, refresh my page to see if it's browser cache, still test1. I go to debugging and walk through the code and find that it goes correctly all the way to here to call the database:
/// <summary>Method that is mapped to the dbo.MemberByEmail database procedure.</summary>
/// <returns></returns>
[System.Data.Linq.Mapping.Function(Name="dbo.MemberByEmail")][code]...
Again I ran the stored procedure through Management Studio, and it came up with test2 as the username. I waited for 15 minutes, refreshing the web page every 5 or so, and it never cleared and served the correct test2 from the db. The last strange piece, I ran IISReset and refreshed the page, test2 was returned.
UPDATE: I created a console application to take out the web piece of it. The problem is the same when accessing directly from a console app also, no change.
I have procedure near below i want to call this procedure through "linq"
I use  mvc 4 and .edmx
//table//
CREATE TABLE [dbo].[Board](
[BoardID] [uniqueidentifier] NOT NULL,
[Board] [varchar](50) NOT NULL
) ON [PRIMARY]
GO
//Procedure //
create procedure [dbo].[GetAllBoard]
as
select * from Board order by Board
I am having problems returning a string value through a stored procedure/linq to a label. Everything works fine if I return an integer value but I cant get a string value to bind to a label. I get the error message
Microsoft.VisualBasic.CompilerServices.Conversions.ParseDouble(String Value,
NumberFormatInfo NumberFormat) +201
Microsoft.VisualBasic.CompilerServices.Conversions.ToInteger(String Value) +66
[InvalidCastException: String "System.Data.Linq.SqlClient.SqlPr" to 'Integer' is invalid‚]
This is the stored procedure
ALTER PROCEDURE test
AS
Select ProductName
From Products
This is the vb page
Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
Dim db As New DataClassesDataContext
Dim product As Integer = db.test.ToString
Label1.Text = product
End Sub
This is the aspx page
<form id="form1" runat="server">
<asp:Label ID="Label1" runat="server" Text=""></asp:Label>
</form>
I have a stored procedure that receives 2 parameters and returns 3 columns.
Here is how I added the SP:
1. Added SP to entity model (.edmx) via update model from DB.
2. Did a Function Import -- selected my SP, clicked "Get Column Information" and then created a new complex type (myStoredProcedureName_Result) which I assigned.
3. My LINQ is the following:
[Code]....