コード例 #1
0
ファイル: PostDao.cs プロジェクト: ralescano/castle
		public virtual Post Update(Post post)
		{
			using(IDbConnection conn = _connFactory.CreateConnection())
			{
				IDbCommand command = conn.CreateCommand();

				command.CommandText = 
					String.Format("UPDATE posts set title = '{0}', contents = '{1}' where id = {2}", 
					post.Title, post.Contents, post.Id);

				command.ExecuteNonQuery();
			}

			return post;
		}
コード例 #2
0
ファイル: PostDao.cs プロジェクト: ralescano/castle
		public virtual Post Create(Post post)
		{
			using(IDbConnection conn = _connFactory.CreateConnection())
			{
				IDbCommand command = conn.CreateCommand();

				// Not the best way, but the simplest
				command.CommandText = 
					String.Format("INSERT INTO posts (title, contents, blogid) values ('{0}', '{1}', {2});select @@identity", 
					post.Title, post.Contents, post.Blog.Id);

				object result = command.ExecuteScalar();
				post.Id = Convert.ToInt32(result);
			}

			return post;
		}
コード例 #3
0
ファイル: PostDao.cs プロジェクト: ralescano/castle
		public virtual IList Find(Blog blog)
		{
			// As you see, no transaction involved here

			IList list = new ArrayList();

			using(IDbConnection conn = _connFactory.CreateConnection())
			{
				IDbCommand command = conn.CreateCommand();

				// Not the best way, but the simplest
				command.CommandText = 
					String.Format("select id, title, contents from posts where blogid = {0} " + 
						"order by id", blog.Id);

				using (IDataReader reader = command.ExecuteReader())
				{
					while(reader.Read())
					{
						Post post = new Post( 
							reader.GetInt32(0), blog, reader.GetString(1), reader.GetString(2) );
						list.Add(post);
					}
				}
			}

			return list;
		}