-
May 18th, 2019, 04:17 PM
#1
Thread Starter
Member
I need some basic help with Entity Framework code first
Hi all,
I'm developing an application under visual studio using C#.
For the database I'm using Entity Framework with code first, and now I've create the database structure, table relations and I can insert registers.
The problem now is I can't find any documentation/tutorial that explain how to retrieve data from the database, delete entries, modify registers and all this.
I know that for someone that know how to do it, it must be very easy, but althought I'd now how to do it in pure SQL I'm unable to implement it.
What I need is the simpliest thing xD
-SELECT * from table where field = value (and then iterate the items retrieves that matches the condition and retrieve data)
-DELETE * from table where field = value
If someone knows a simple tutorial or similar that explain it, I would thank a lot.
Regards
-
May 18th, 2019, 04:55 PM
#2
Re: I need some basic help with Entity Framework code first
https://docs.microsoft.com/en-us/ef/ef6/querying/ should give you an idea of how to query the model.
Modifying data is a matter of retrieving the data you want to modify, probably by using a query, and then calling the .SaveChanges method of your context.
IIRC the context should also offer a .Remove method, simply pass in the item you wish to remove and call .SaveChanges and it should be deleted.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|