|
|
I would like to discuss the process of setting up the Entity framework. It has some learning curves to it and would like to outline the process and share this with others. Help me fill in the blanks and add comments as you have learned it. Realize the object names in the container look just like your tables and fields - so your will not be exactly like the example here.
Most database objects have a Fill method. So how does Entity load the model, with the creation of the Entity Container! Too simple? I think so. If you have not learned LINQ you should it is pivotal to this experience.
Steps:
1) Build you database,
2) setup your tables and relations,
3) setup the server explorer in VS,
4) add the project data source (using Entity),
5) Imports;
Imports System.Data.Objects
Imports System.Data.Objects.DataClasses
Imports <your program namespace>.<your entity name>
6) create the instance of your entity container
Dim model As New DM_dbEntities
Add a new record:
model.Records.AddObject(New Record With {<the fields initialized here>})
Dim rec As Record = Record.CreateRecord(<int id>)
model.Records.AddObject(rec)
model.SaveChanges(<save option>)
That's it for the setup. Feel free to make comments or suggestions!
The only constant is change... - Isaac Asimov
modified 26-May-12 20:26pm.
|
|
|
|
|
There is some useful information on it here[^] and here[^].
|
|
|
|
|
Thanks for the links. I am more looking for discussion and making a simple outline for people who are new to it as it is very different than normal database setups. I don't even want to get into queries in here, just the setup and experiences people have to share with community. Mainly cause this is where I am, learning it, and have questions about it. Searching the documentation is not as easy of a read either. Thanks again.
|
|
|
|
|
|
Seriously! Can't you see I already made the changes to my first post that outlines the process in a simple and understandable version instead of all the crappy searches. I am not looking for an answer - I have it. So if you have some discussions please do, stop sending links!
|
|
|
|
|
Yes, seriously! Read the link I gave you about how to ask a question.
|
|
|
|
|
My definition of discussions and questions seem to be different than yours. Maybe try reading my posts again. Some options left open here are connections and modifying them.
|
|
|
|
|
It's not my definition it's that of the site owners, and I think you've been a member here long enough to figure out how it works.
|
|
|
|
|
This isn't really a suitable place for this as what you have added here is not a question. Why not make it a Tip/Trick, so that it doesn't disappear when more questions are added to this page?
|
|
|
|
|
The name for this forum is discussions. But thats fine.
|
|
|
|
|
Is it? I can't see that anywhere, but the reason I recommend a tip/trick is that it doesn't disappear from view quickly the way a question can.
|
|
|
|
|
That's the only way I can get here is to click on 'Discussions' on the green menu bar. I found the answer while posting here while waiting for some discussion on the topic. I do think I will make it a Tips/Trick thing - thanks.
|
|
|
|
|
Ah, sorry. I get you - I always use the menu at the left, so I forget about that menu.
|
|
|
|
|
I have a button in my form and on click of that button I am writing this code....
<pre>
OdbcCommand cmd ;
cmd = new OdbcCommand("abc", cn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.ExecuteNonQuery();
I have made a procedure named abc in database which is returning only one row from login table..So i am just checking that on click of that button my procedure should run but while debugging when i come to cmd.ExecuteQuery() it throws following error..
ERROR [42000] [MySQL][ODBC 5.1 Driver][mysqld-5.0.77-community-nt]You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'abc()' at line 1.
So plz sort out the problem as soon as possible...
|
|
|
|
|
nitish_07 wrote: So plz sort out the problem as soon as possible..
This is not the most polite way to ask for help.
If you look carefully at the error message it gives clear details about where the problem lies, and what you need to do about it.
Programming is work, it isn't finger painting. Luc Pattyn
|
|
|
|
|
Your procedure returns a row of data, but you use a method that doesn't return anything with ExecuteNonQuery . Do you see the problem yet?
|
|
|
|
|
ya i know....but till that point code should run correctly....I am just checking...
|
|
|
|
|
Well, it's not, obviously.
The says that there's something wrong with your SQL SELECT statement, which we can't see. Sooooo.... where do you think you should be looking?
|
|
|
|
|
ExecuteNonQurey should only be used for inserts, updates and deletes, if your preforming a select you should be saying ExecuteReader to return what ever you want, hope this helps, need any more help just ask.
|
|
|
|
|
OdbcCommand cmd;
cmd = new OdbcCommand("abc", cn);
cmd.CommandType = CommandType.StoredProcedure;
OdbcDataReader dr = cmd.ExecuteReader();
while (dr.Read())
{
string s = dr.GetString(0);
}
after doing this I am getting the same error after line cmd.commandtype=cmd.executereader...
now what should i do..it says odbcexception was unhandled..
|
|
|
|
|
Like I said yesterday, the exception message is reasonably clear that there is a problem in your stored procedure abc() . If you cannot figure out what is wrong with it then post it here so an SQL expert can help.
|
|
|
|
|
Sir there is no problem with my stored procedure..It is working fine in database..when i call through c# it throws error...
|
|
|
|
|
There's obviously some problem there. If you refuse to give us the full information we cannot help.
|
|
|
|
|
This is my procedure abc..
DELIMITER $$
DROP PROCEDURE IF EXISTS `userdb`.`abc`$$
CREATE DEFINER=`root`@`localhost` PROCEDURE `abc`()
BEGIN
select * from login;
END$$
DELIMITER ;
|
|
|
|