Incorrect Component When Querying Immediately After Insert Using NHibernate?

Apr 5, 2010

I have the following mapping for my table in MySql:

<class name="Tag, namespace" table="tags" >
<id name="id" type="Int32" unsaved-value="0">
<generator class="native"></generator>
</id>

[Code]....

As you see the record_dates property is defined as a component field of type DateMetaDate. Both created_at and updated_at fields in 'tags' table are updated via triggers. Thus I can insert a new record like such:

var newTag = new Tag()
{
name = "some string here"
}
Int32 id = (Int32)Session.Save(tag);
Session.Flush();
ITag t = Session.Get<Tag>(id);
ViewData["xxx"] = t.name; // -----> not null
ViewData["xxx"] = t.record_dates.created_at; // -----> is null

However when querying the same record back immediately after it was inserted the record_dates field ends up null even though in the table those fields have got values.

why the Session.Get ignores getting everything back from the table? is it because it caches the newly created record for which the records_dates is null? If so how can it be told to ignore the cached version?

View 3 Replies


Similar Messages:

.net - NHibernate Paged Results & Incorrect Row Count?

Mar 10, 2011

I have a model called 'BusinessPage' which can be associated with 1 or more 'BusinessPageCategories'. So I've got a 3rd table called 'BusinessPagesInCategories' that links these two.I am trying to get a paged recordset of BusinessPages, along with the total number of records (I may have 100 rows in total but only return 20 at a time, but I pass back an int containing that total number in addition to the 20 rows).The problem I have is that, since I implemented the Many-To-Many relationship, it was bringing back the same BusinessPage row x times (where x is the number of categories that BusinessPage is associated with). I only want a single instance of each business page to be returned. So I added the following to my NHibernate Criteria to give Distinct BusinessPage results..SetResultTransformer(CriteriaSpecification.DistinctRootEntity);

Whilst this works for me, in that I'm now correctly getting a single row per BusinessPage (and my Categories property within each BusinessPage contains the correct x categories that it's assigned to), my row count is not reflecting that 'distinct' count - instead, if I have just 1 BusinessPage record which is associated with 3 categories, the row count is 3!?!

public virtual int BusinessPageId { get; private set; }
public virtual IList<BusinessPageCategory> Categories { get; set; }
public virtual string BusinessName { get; set; }

[code]...

View 1 Replies

ADO.NET :: Retrieve A New Row ID Immediately Upon Insert With LINQ?

Sep 26, 2010

How can I retrieve the row ID immediately as I insert a new record with LINQ? I need to refer back to it to update the row since it will be the only unique data in this particular table ( it's the primary key and the ID number is auto generated)

View 3 Replies

Fluent NHibernate Cascade - Trying To Insert NULL ID?

Mar 8, 2011

I have the following models & mappings (code snippets further below).

One Competition has to have multiple CompetitionAnswers associated with it (multiple choice) from the outset.

At present, using the Fluent NHibernate mappings shown below, when I create a brand new Competition object, populate the properties, then create 3 brand new CompetitionAnswer objects and add them to the CompetitionAnswers property (property on Competition), I would expect to call Save on the session which would INSERT the 1 Competition row and 3 CompetitionAnswer rows to the DB.

However, as soon as I try to call Save on the session, it complains that CompetitionId is null and it can't insert a null into the CompetitionAnswers table for that field - which is right, it shouldn't, however, I assumed that the NHibernate would first create the Competition, then use the newly generated IDENTITY value (CompetitionId) in the CompetitionAnswers table?

[code]....

View 3 Replies

Getting This Error Incorrect Syntax Near ','when Try To Insert Row In Sql Database?

Jan 1, 2011

i am getting this error incorrect syntax near ',' when i try to insert row in sql database through vb.net. the same command works for all tables but i get error in this.

VBNET Code:
Dim cmd1 As New SqlCommand
cmd1 = New SqlCommand("insert into
[code]......

View 4 Replies

DataSource Controls :: How To Fail Data Flow Component From Script Component

Aug 3, 2010

I am trying to stop the data flow when certain conditions happen in the script component. Like if a row in the data set has an invalid date, I dont want that dataset to be inserted in the tables or go through OLEDB Destination, rather I want the entire data flow for that dataset to stop and go back to the control flow page.

I have tried mulitple solutions but nothing worked. Conditional Split ends up inserting the correct rows, but I just dont want anyting to be inserted when one row is bad, where as I do want the entire dataset to be inserted if all rows are good.

How can I fail the component when certain conditions happen int eh script component.

View 1 Replies

ADO.NET :: Error "Incorrect Syntax Near 's'" On Insert Record

Jan 25, 2011

ERROR MESSAGE: Unclosed quotation mark after the character string ') '. Incorrect syntax near 's'. I am getting this error when adding a value to a table which contains a single quotation, value is: men's that value is been pass as the keyword name. this is the query that i am using: Dim sql2 As String = "INSERT INTO keyword_relation_type (business_id, keyword_name, keyword_id) VALUES ('" & business_id & "','" & keywords(i) & "','" & keywordsID(i) & " ') "

View 1 Replies

Web Forms :: Master Page Function Listing Component In Child Page (asp:Localize Component)

May 18, 2010

I would like to know how can I list for every page (child page) selected the number and id of localize component in the current page. I need this to update resources files, a button will be on the master page and when they click on it, they will go to a page which show up every data in the resource file.

View 1 Replies

Forms Data Controls :: There Is Already A Component Named ".." Component Must Have A Unique Name

Feb 10, 2011

i got a problem.. how i can declare template textbox in a datagrid at code behind? i already make a stored procedure and put the update query inside it.. if i declare the textbox inside code behind(.aspx.vb).. there will be an error.. " there is already a component named "txtitem1"component must have a unique name.."

Dim con As New SqlConnection(ConfigurationSettings.AppSettings("ConnectionString1"))
Dim cmd As New SqlCommand
Dim sda As New SqlDataAdapter
cmd.CommandType = CommandType.StoredProcedure
cmd.CommandText = "ETendering3"
cmd.Parameters.Add("@item", SqlDbType.NVarChar).Value = txtitem1.Text
cmd.Parameters.Add("@price", SqlDbType.Decimal).Value = txtprice1.Text
cmd.Parameters.Add("@remark", SqlDbType.NVarChar).Value = txtremark1.Text
cmd.Parameters.Add("@consump", SqlDbType.Decimal).Value = txtconsump1.Text
cmd.Parameters.Add("@value", SqlDbType.Decimal).Value = txtvalue1.Text
cmd.Connection = con
Try
con.Open()
DataGrid12.DataSource = cmd.ExecuteReader()
DataGrid12.DataBind()
Finally
con.Close()
End Try
con.Dispose()
cmd.Dispose()
con = Nothing
cmd = Nothing
_______________________________________________________
.aspx
<Columns>
<asp:BoundColumn DataField="Listing_Id" HeaderText="Listing"></asp:BoundColumn>
<asp:BoundColumn DataField="No" HeaderText="No"></asp:BoundColumn>
<asp:BoundColumn DataField="Item_Category" HeaderText="Category"></asp:BoundColumn>
<asp:TemplateColumn HeaderText="Description">
<ItemTemplate>
<asp:TextBox id=TextBox1 runat="server" Text='<%# DataBinder.Eval(Container, "DataItem.Item_Description") %>'>
</asp:TextBox>
</ItemTemplate>
<EditItemTemplate>
<asp:TextBox id="txtitem1" runat="server"></asp:TextBox>
</EditItemTemplate>
</asp:TemplateColumn>
<asp:TemplateColumn HeaderText="Price" FooterText=" 10/50">
<ItemTemplate>
<asp:TextBox id=TextBox3 runat="server" Text='<%# DataBinder.Eval(Container, "DataItem.Price") %>'>
</asp:TextBox>
</ItemTemplate>
<EditItemTemplate>
<asp:TextBox id="txtprice1" runat="server"></asp:TextBox>
</EditItemTemplate>
</asp:TemplateColumn>
<asp:TemplateColumn HeaderText="Remarks">
<ItemTemplate>
<asp:TextBox id=TextBox2 runat="server" Text='<%# DataBinder.Eval(Container, "DataItem.Remark") %>'>
</asp:TextBox>
</ItemTemplate>
<EditItemTemplate>
<asp:TextBox id="txtremark1" runat="server"></asp:TextBox>
</EditItemTemplate>
</asp:TemplateColumn>
<asp:TemplateColumn HeaderText="Consumption">
<ItemTemplate>
<asp:TextBox runat="server" Text='<%# DataBinder.Eval(Container, "DataItem.Consumption") %>'>
</asp:TextBox>
</ItemTemplate>
<EditItemTemplate>
<asp:TextBox runat="server" ID="txtconsump1"></asp:TextBox>
</EditItemTemplate>
</asp:TemplateColumn>
<asp:TemplateColumn HeaderText="Value">
<ItemTemplate>
<asp:TextBox runat="server" Text='<%# DataBinder.Eval(Container, "DataItem.Value") %>'>
</asp:TextBox>
</ItemTemplate>
<EditItemTemplate>
<asp:TextBox runat="server" ID="txtvalue1"></asp:TextBox>
</EditItemTemplate>
</asp:TemplateColumn>
</Columns>

View 38 Replies

SQL Server :: EXEC 17P_Comose Will Give Incorrect Syntax Error - Incorrect Syntax Near '17'

Sep 15, 2010

I am working with a sql server database with about 50 stored procedures. The database and stored procedureswere not created by me. The stored procedures all begin with a number in their name.

Example: 17P_Comsetter

The problem I am having is that if I try and execute the stored procedure at the command line in Query Analyzer,the query analyzer appears not to like that the stored procedure begins with a number. For example:

If I try an run the stored procedure as follows:

EXEC 17P_Comsetter

Then I get the following error message:

Msg 102, ..... Incorrect Syntax near '17'

I am using SQL server 2005. Does anyone know why I am getting this error message?

View 1 Replies

ToList And Querying Multiple Entities?

May 13, 2010

I have the following code for the SelectedIndexChanged event of a drop down list. This works fine as it is but this entity has a relationship to another entity (Genre). if i change the select statement to { m, m.Genre.MovieGenre }).ToList(); it doesnt work as contains anonomyous types.

[code].....

View 1 Replies

DataSource Controls :: Querying SQL Database?

Jan 10, 2010

I have an SQL database which I wish to query, I have the queries set out and working using the SQLDataSource Control.Is there any way of using web methods to query an SQL Database.I realize this may not be ideal when the SQLDataSource control offers such functionality but it is for a piece of college work and I am not entirely sure which way they want it to work, as all it says is to "Implement a client application and a set of web services".

So is it possibile to use a WebMethod to perform SQL based queries or queries which are not SQL based and if so how do you go about creating them?

View 4 Replies

DataSource Controls :: Querying One To Many Relationship DB C#?

Mar 23, 2010

I have a database which contain job ads/ I have one table "dbo.tbl_jobadvert" which contains the ad itself and another table "dbo.tbl_jobFiles" which contains the path of the documents uploaded in relations to the job advert ( application form, job description, etc )

[Code]....

View 1 Replies

DataSource Controls :: Querying A Databse From Within A VB Sub?

Jul 2, 2010

I'm using Visual Web Developer 2010 Express with SQL server 2008 Express and I'm wondering if it is possible to query the database from within a VB subroutine located within pagename.aspx.vb, rather than just using the asp databound controls on the main page ?

I want to do something like this in the page load routine:

Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
Dim username As String
username = GetUserName() 'calls function to get current username
Now connect to database and perform SQL command (SELECT FirstName FROM dbo.USERS WHERE UserName = username)
Assign the retuned data to a label: lblFirstName.Text
End Sub

Is it possible ?

View 7 Replies

Get VB Anonymous Methods Working - Querying Lists?

Jul 1, 2010

I am trying to get my code working as per the instruction on [URL]

Public Delegate Function PredicateWrapperDelegate(Of T, A)(ByVal item As T, ByVal argument As A) As Boolean
Public Class PredicateWrapper(Of T, A)
Private _argument As A
Private _wrapperDelegate As PredicateWrapperDelegate(Of T, A)
Public Sub New(ByVal argument As A, _
ByVal wrapperDelegate As PredicateWrapperDelegate(Of T, A))
_argument = argument
_wrapperDelegate = wrapperDelegate
End Sub

Private Function InnerPredicate(ByVal item As T) As Boolean
Return _wrapperDelegate(item, _argument)
End Function

Public Shared Widening Operator CType( _
ByVal wrapper As PredicateWrapper(Of T, A)) _
As Predicate(Of T)
Return New Predicate(Of T)(AddressOf wrapper.InnerPredicate)
End Operator
End Class

Then I have the function which I have modified to use my department id variable (did)

Function DidMatch(ByVal item As ListDataItem, ByVal did As Integer) As Boolean
Return item.AssigneddepartmentID.Equals(did)
End Function

Then I try to call it from my code:

Dim children As List(Of String) = toplevel.FindAll(New PredicateWrapper(Of Integer, Integer)(Did, AddressOf DidMatch))

I then get an error on DidMatch ... Error Method 'Public Function DidMatch(item As DeptMenuData, did As Integer) As Boolean' does not have a signature compatible with delegate 'Delegate Function PredicateWrapperDelegate(Of Integer, Integer)(item As Integer, argument As Integer) As Boolean'.

View 1 Replies

Mobiles :: Developed A Data Querying Application For The Web

May 3, 2010

I have developed a data querying application for the Web, this is in a host. What steps should I take if I want this application can also be used with mobile devices.

View 3 Replies

C# - Querying Database Using The Same Date Does Not Return Data?

Mar 2, 2010

I have a little problem with a query. I'm selecting data using the between command, But when I select the initial date equal to the final date the query doesn't show data.I know that the problem is the format. In my database I got something like this:2009-05-22 15:32:52.000. But when I send the date parameter from ASP.NET Page I sent only the Date (2009-05-22).So, I want to fix this thing. I cannot change the Datetime inside the database.I was thinking adding 1 day to the final date, So when the user select the same date I change the range behind the scene and then show the data. What do you think?

View 8 Replies

SQL Server :: Querying SQL Table For Conflicting Values?

Mar 8, 2011

I have this table in SQL that I'm trying to do some comparison work with Ok, onto the schema. It's like this:

[Code]....

Now, what I want to do is query my database in this manner:Display any records that conflict only Non-priority conflict based on: priority based on the time of day

[Code]....

View 4 Replies

Querying Remote Data Stores From Application?

Dec 5, 2010

I am writing an ASP.NET application that suppose to connect to many different data stores and query them for data. Each data store contains different data: it can be an SQL DB, an XML file, or anything that can store data. The result is always an XML.

The remote data stores expose a WCF service (which I will also implement) that will allow me to query the data store and return the results.

My question is: how exactly should I implement the querying mechanism? Should I define my own query language?

View 1 Replies

C# - Querying LDAP For Usergroup Of Specific User?

Mar 16, 2011

I have to check usergroups of LDAP Active Directory for a specific user in C#. Mean I pass this username to a method and it returns me list of group from that user belongs. Im Searching alot But Everytime get new error.

LDAP Path: 192.168.1.4
Domain Name: Arslan
UserName: ArslanP
Password: testad

View 2 Replies

C# - Querying Multiple Databases Using Distributed Web Services?

Feb 5, 2011

I have a quick question about best practices and especially expected performance for the following scenario:

If I want to query data from multiple servers that contain schematically identital sql databases, would having each server provide a web method that a single client application can consume be an appropriate (and relatively fast) solution?

The data just needs to be consolidated on the client end, where several web methods would have to be consumed serially (or in parallel?) to provide the data to the client. Each server would also be implementing Entity Framework as an ORM.

Performance is my main concern here, would it turn out excessively slow as we start to scale up to more and more servers?

View 2 Replies

DataSource Controls :: Querying Across Associations With Listview And Linqdatasource?

Feb 12, 2010

With the gridview I can create a template field to query across associations but I don't see how its possible to do that with the listview (?). I tried to create associations in the eval fields

(ie productId.Brand) where productId is in the Reviews table and is associated with the Products table - and Brand is a member of the Product table but it was no go?

[Code]....

<b>Title:</b> <%# Eval("Title") %>

View 4 Replies

DataSource Controls :: Querying & Updating Data From Dataset?

Mar 15, 2010

I'm hoping someone can point me in the right direction. I will be as detailed as I can in explaining the issue;I have a dataset I have instantiated in a class file (vb.net), and fill the data succesfully. That data is then dumped into an excel file. What I need to do is to go through all the data in the dataset, and directly update the database, changing a "status" column from "pending" to "processing" based on the store number. As I am new to datasets (relatively speaking, of course), I am not quite certain how to accomplish this task. Below is the code I have so far:

[Code]....

If anyone could provide sample code to use, or could provide a quick bit of code I could just copy and paste in and test,

View 1 Replies

Forms Data Controls :: Noob Stuff: Querying Any Value From SQL Database?

Jan 10, 2011

I'm trying to create a search page that searchs one specific table in the entrie datbase.Basically someone writes what they want in a textbox in search.aspx, they click the search button, and it takes them to another page called search_results.aspx, carrying the inputted text along with it. What search results is supposed to do is at page load, its supposed to query the entire database for all values that are LIKE the text in the querystring, then transport the entire value set of each row that has a field matchign the query string, and then it's supposed take those values and put them in a template that presents them in the way that I want.

The only thing out of all that that I don't know how to do is write the code for taking the querystring and putting it up against all the values in the database like that. I know that you can find a value in a specfic comlumn, i.e.

SELECT Column1, Column2
FROM Table1
Where Column1 = 'blah1', 'blah2'

but how do you write it so that it looks at all the columns for 1 or 2 specfic values (the querystring), and then it returns the entire for each time it finds them?

View 7 Replies

ADO.NET :: Querying Derived Types But Only With Specific Values / LINQ To Entities?

Nov 5, 2010

I can't find the answer to this easy question, because I don't know the terminology I am looking to use. I have 2 tables, one that is a Users Table, and another (UserProfiles) that extends the Users table to include more info, like Age, Sex, Weight, etc.I am using the Entity Framework as my model, and the UserProfiles inherits from the Users table on a 1:1 basis.

All I need to do is the learn the syntax, that allows LINQ to Entities to query only some of the data from UserProfiles. For example, maybe I only need Sex and Weight, but not Age.

[Code]....

View 4 Replies







Copyrights 2005-15 www.BigResource.com, All rights reserved