I am working on a silverlight project in which i am using the entity data model. I have a consol application in the same solution through which i am creating the database table at runtime. Now when i moves to silverlight page i need to update those newly created database table in the entity data model. Is there any way to update model at runtime.
View 1 RepliesI want to update an entity without loading the entity from the database first. I've accomplished this but only by knowing all of the entities properties and then using the "attachto" method. My issues is i don't want my app to need to remember all of the properties. Example:
[Code]....
I have a problem with Firefox and Silverlight. I have a silverlight application (with version-number 1.0.0.0) on my website. Now I have modified the silverlight application(version-number is now 1.0.0.1) and replaced the old file on the server with my new application.
The Internet Explore loads the new application correctly. But unfortunally the Firefox 4 still loads the old Silverlight application.
At first I was using this as an extension method to update my detached entities...
Public Sub AttachUpdated(ByVal obj As ObjectContext, ByVal objectDetached As EntityObject)
If objectDetached.EntityState = EntityState.Detached Then
Dim original As Object = Nothing
[code]....
Everything has been working great until I had to update non-scalar properties. Correct me if I am wrong but that is because "ApplyCurrentValues" only supports scalars. To get around this I was just saving the FK_ID field instead of the entity object relation. Now I am faced with a many to many relationship so its not that simple. I would like to do something like this...
Dim Resource = RelatedResource.GetByID(item.Value)
Condition.RelatedResources.Add(Resource)
But when I call SaveChanges the added Resources aren't saved. I started to play around with self-tracking entities but it seems they cannot be serialized to ViewState and this is a requirement for me.how to either save my many to many relationships or serialize self-tracking entities?
I'm trying to update a specific record based off of a users selection. Regarding Entity Framework syntax, I'm not very familiar. Is it possible to achieve this SQL statement in Entity FrameWork?
View 3 RepliesI would like to update a row like this:
update [approvers] set approvalstatus = True Where approvalstatus = False and bookingID = @bookingid and approveremail = @email
Using the entity framework.
I have my query which should deliver the item like so:
Dim db As New Model.Entities
Dim approvers = From a In db.approvers Where a.ApprovalStatus = False And a.BookingID = BookingID And a.ApproverEmail = UserName Select a.ApprovalStatus
How do I next target this record for update, so that I can set a.approvalStatus = True then commit these changes to the db?
I'm trying to update one value of a compound primary key from within the entity framework and I'm getting this error: "The property 'CustomerID' is part of the object's key information and cannot be modified. "[code]...
View 4 RepliesI have 2 tables in my DB: "Competitions" and "CompetitionAnswers". Each competition will always have 3 answers. I want to be able to edit the Competition and CompetitionAnswers for the same view. I have managed to get the view to work by using editor templates So this is my editor template:
[Code]...
I've got a class that closely resembles one of my entities (I use the class for JSON de/serialization because the entity fails conversion to JSON, one of the known gotchyas of JSON + MVC).Once I deserilize a JSON string into my object, is there a way to automatically update the associated Entity model instance. The property names are the same.
'myDeserialized is the deserialized JSON object coming over the wire
Dim entityInstance As DLL.Person = db.getPersonById(myDeserialized.id)
myDeserialized.update(entityInstance)
[code].....
How to update the existing Customer object, Insert new Computer object and Add new WorkOrder using entity framework? [code]
View 2 RepliesI have a GridView that is tied to an EntityDataSource. Most columns are normal bound columns, but two are itemtemplates. When I attempt a delete on one of the rows I receive the following message:
"A property named 'Building1.building_name' was not found on the entity during an insert, update, or delete operation. Check to ensure that properties specified as binding expressions are available to the data source."
I'm not sure how it is possible that this isn't available, since it displays the element just fine when I'm just viewing - it just throws the error when I attempt deleting a row?
I have the following LINQ-to-Entities query:[code]This will give me all the resident assignments for the current year/term. Then I have this LINQ-to-Entities query:[code]This will give me all the rooms. I want to iterate through the assignments and based on what room is assigned update the occupancy in reset_occupancy. I'm not 100% sure how to accomplish this. Here is my pseudo code of what I want to accomplish:[code]
View 1 RepliesI have the following LINQ-to-Entities query:
' Get all the residency assignments that match the term/year.
Dim assignments = From p In dbContext.Residents _
Where p.semester = term _
[code].....
I am trying to build a survey engine from an existing database design which is like this.
[Code]...
The line Order By Key.RecordOrder throws a null reference exception and I can understand why. Can someone advise on how to resolve this by just modifying this one query? I am fairly new to LINQ and the necessity to write this project
[Code]...
I have a LOB app written in VB.NET with a WinForms front-end and SQL back-end. After many months weighing up how to get onto the Web, I decided last month to use Silverlight 2. Now, Silverlight 3 Beta is out, but there is no end-user runtime.
Does anyone know when the runtime will be available for deployment of SL 3 apps onto client sites?
My dev timeline is about 3 months: should I persist with SL 2 and then u/g to SL3, or jump straight in to SL3?
Entity Splitting: one class, two or more tables.Here is how it is done in C#, but I need to get it working in vb.net.One more thing: the class name and table columns do not match, so I have to be able to map that out, too.I have to get this to work this way because the place I'm working at right now is a vb.net only shop and the database schema is fubar, but they have so much (millions) of lines of code done directly against the database in both asp classic, vb.net, AND asp.net webforms that changing the schema right now is not realistically possible.
protected override void OnModelCreating(DbModelBuilder modelBuilder)
{
modelBuilder.Entity<Post>()
.Map(m =>
[code]....
I am trying to jump from ASP Classic to asp.net. I have followed tutorials to get Entity Framework and LINQ to connect to my test database, but I am having difficulties figuring out ExecuteQuery(). I believe the problem is that I need an "entity class" for my database, but I can't figure out how to do it. Here is my simple code:
Dim db as New TestModel.TestEntity
Dim results AS IEnumerable(OF ???) = db.ExecuteQuery(Of ???)("Select * from Table1")
From the microsoft example site, they use an entity class called Customers, but I don't understand what that means.
I am trying to create a generic typed class, but am running into a problem. Here is my basic class definition:
public class QueueObject<T> where T : System.ServiceModel.DomainServices.Client.Entity
{
public string LoadingMessage { get; set; }
public System.ServiceModel.DomainServices.Client.EntityQuery<T> Query { get; set; }
}
I am trying to add instances of this class to a queue
private Queue<QueueObject<Entity>> _queue;
this._queue.Enqueue(new QueueObject<MyEntity> {Query = MyContext.GetMyEntitiesQuery(), LoadingMessage = "Loading some stuff"});
This doesn't work. I get an error saying that QueueObject cannont be converted to QueueObject. I don't understand because MyEntity inherits from Entity.
Public Class QueueObject(Of T As System.ServiceModel.DomainServices.Client.Entity)
Public Property LoadingMessage As String
Public Property Query As System.ServiceModel.DomainServices.Client.EntityQuery(Of T)
End Class
[code]....
I want to make my applications to have a self update function. My applications have only one file, the main .exe. For updating, I want to use the best way: the program download it's new version overwriting itself; and on next start the program will be the updated version. I tried to use the ShadowCopyFiles, but all the times the main file is locked, so cannot overwrite it (or delete or anything). I found many examples in the internet like this:
[Code]...
i m having problem while updating my database... In this code when i delete records then it will deleted but it can't show updated data..for viewing new updated data i hav to again open the form ... so is there any code which i miss? to update database @ runtime?
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
Dim con As New OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0;Data Source=D:\SmS Application\New.mdb")
Dim cmd As New OleDbCommand
Dim ds As New DataSet
[code]....
I have a project with widnow forms. On a form i hava a textbox, datagridview and a button. My datagridview is bounded to my database. I will like some help with updating datagridview with text that i add with my button to database. I tried the update and refresh on my datagridview but there is no update seen when form is active. If i close and open the form then the changes are being seen on datagridview. This is my code for button click event:
[Code]...
I am popolating a DataGridView with a DataSet from an SQL database like in example bellow.
After I am making some changes I need to know how can I save modified data in SQL database>
Let's say that I have a form with a DGV and a button. On load I will put ten lines from a tbale from database inside the DGV. Then i will make some changes and after that when I click on the button I need to save the modified information. Everything has to be done on runtime.
[Code]...
I am using Visual studio 2008. I didn't see a place to post questions about this . I am creating a mobile application, at run time the executable itself is not updating to show the changes from source code i have written. I feel there must be a setting or something in visual studio .
View 3 Repliesc# - Are Microsoft Entity Framework and ADO.NET Entity Framework (.edmx) the same?
View 7 RepliesI'm trying to update pictures boxes with images of controls stored in an imagelist owned by a control. The images stored in the control.imagelist do not showup in the picturebox. I'm working on simplifying the code to post, but for now could use help.If I store the image in a member variable owned bythe control it woks fine.Something to do with persistance of images in control owned imagelist? [code]
View 2 RepliesI have created multiple dropdown list at runtime and populated with data. I also have added an eventhandler to determine the selected value of the drop down list.
The code is as follows :
Dim tbl As New Table()
tbl.EnableViewState = "true"
[code].....
I have a Visual Basic 2005 program which runs fine if I execute the built Executable. However if I start the application in VS2005 debugger it gives a weird error
[Code]...
I am trying to implement multibinding in Silverlight using VB.Net. I have found a very good reference for an implementation in C# here. I spent some time trying to use various converters to migrate it into VB.Net but I still didn't get it working properly. So..
I'm looking for some references that exemplify how MultiBinding can be done in VB.Net. Also an example using Silverlight 5 beta would be fine (I read in a post right here on Stack Overflow that it supports multibinding).
is it possible to write xml in silverlight with vb
View 5 Repliesif this has been asked before (I couldn't find the answer anywhere), but I have a WCF Service Application that I have created, and am trying to access via my Silverlight 4 app. I have added the service reference to the SilverLight App and am just trying to call one of the default pre existing methods on the service (GetData). When calling the method i get an error of:
[Code]...