public string[] GetFromDatabase() { string[] listMessage = new string[4]; using (chatting_rpcEntities1 chattingData = new chatting_rpcEntities1()) { try { var query = (from tabelchat in chattingData.chats orderby tabelchat.id descending select tabelchat).Take(1); foreach (var item in query) { listMessage[0] = item.id.ToString(); listMessage[1] = item.username; listMessage[2] = item.text; listMessage[3] = item.date.ToString(); } } catch (Exception ex) { Console.WriteLine(ex.Message); } return(listMessage); } }
public void SetToDatabase(string username, string text) { using (chatting_rpcEntities1 chattingData = new chatting_rpcEntities1()) { try { chat newChat = new chat(); newChat.username = username; newChat.text = text; chattingData.chats.Add(newChat); chattingData.SaveChanges(); } catch (Exception error) { Console.WriteLine(error.Message); } } }